Automate Database Migration, Database Conversion - Automation Anywhere Example. The Automation Software.

Call: 1-888-484-3535

Home > Product > Solutions > Data Integration / Data Automation > T31

T31 - Automate Database Migration. Transfer data from one Database to other

Task Description

Query the database, get the data and transfer that data to other database.

Solutions

	Create a new task Click on New - > Task Editor	Screenshot 1 Screenshot 2
	Connect to the source database Using the Database command from the Application category, specify a connection string to connect to the source Database. Connect to '<database connection string>'
	Specify a SQL Query to get the data from the database Using the Database command from the Application category and selecting SQL Query Option specify a SQL Query Execute SQL Statement: Select * From OrderMaster
	Connect to the target database Insert Database command to connect to the target database where you want to transfer data.
	Transfer the data Using the Loop command and selecting "Each row in a SQL Query Dataset" option, you can Loop through each row of the result returned by the query Inside the Loop Block, specify Insert query to insert records in destination database. Note: To access values of different columns in the dataset use the index 1,2,3 etc with the System Variable $Dataset Column$.

When you run this task, it connects to the source database , retrieves the data and fill dataset with data fetched from database. With insert query in loop it will add all the records to destination table in database.

Next Steps
	Buy now
	Download free trial
	Compare versions
	Watch a flash demo
	Contact me
	Ask the Expert
	Request live demo

Call 1-888-484-3535

Our Customers

We started using this product to copy data from legacy system to new system. Now we use it just to do about anything automated. Countless hours saved. Thank you guys.

- Jack Greenberg

Read Customer Testimonies >>

Products Download Purchase Services Support Customers Company Sitemap Trademark