You are here: Home » All Software Solutions » How to transfer data from one database to other?
How to transfer data from one database to other?
Automation Anywhere is an intelligent automation software for IT & business processes.
Recover lost, deleted and formatted image, audio and video files from removable media, camera cards, memory sticks and hard drives - Digital Media Recovery Software
|
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 ' |
|
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 | ||
Screenshot 1:
Screenshot 2:
Related Software: Automation Anywhere -
Recommended Essentialware
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.
Windows media player 12
With it, you can play audio, video and viewing images on Windows 7 and have a great experience.
Norton Internet Security 2010
Norton Internet Security 2010 offers comprehensive protection against all types of online threats.
WinRAR 3.9
WinRAR is an powerful archiving utility that completely supports RAR and ZIP archives.
Recommended Mac Software
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.
by on 20/08/2007Web Developer
Senuti for Mac
Use Senuti to quickly and easily transfer music from your iPod or iPhone to your Mac.
VLC Media Player for Mac
VLC for Mac OS X is distributed as a disk image. Download the .dmg file, open it, and copy VLC to your hard drive.
iSquint
iSquint a program for converting videos from the internet to iPod or TV.
Tags:Automation Anywhere, transfer database to other, automation software for IT, task chaining, web mining, turbo-speed, ie plug-in
Top Reviews
on Web Developer
Adobe Flash Player - SWF Player"Cross-platform flash video plug-in for web browsers to deliver users wonderful visual effects."
by Owen Wilson on Sep 7, 2009
Flash Gallery Builder"Flash Gallery Builder Reviews & Free Download"
by Heren Watson on Jan 10, 2008
