Automation Anywhere - The Automation Software

Data Transfer & Data Migration -> 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.

Solution
1.	Create new task	Click on New->Task Editor.
2.	Connect to the source database	Using the Database command from the Application category specify a connection string to connect to the source Database Screenshot 1. Connect to '<database connection string>.
3.	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*
4.	Connect to the target database	Insert Database command to connect to the target database where you want to transfer data.
5.	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. Screenshot 2 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.

Customer Testimony

"This has to be the best automation software around. I tried the competition and even combined they offer only a tiny fraction of the functionality of this program! The first macro I wrote will save me about 20 minutes every day. This updates a database from online resources that I did manually. Windows scheduler could never perform this task because it requires user input. Setting up the macro took about 2 minutes. Editing it about another 2 minutes. I schedule it to run after midnight and now I don't have to worry about it. I am now creating a list of regular tasks that can be done using Automation. Excellent work guys! - Mike Montgomery, MjM Data Recovery Ltd

Read more Customer Testimonies

Screenshot 1: