How to copy data from one database to another? (4225476)

How do you copy data from one database to another in Toad?

There currently is no automatic copy data function between different databases.

RESOLUTION #1

To copy data from one database to another | export the data to a file | then import those data files into a similar table on another database.

For example:
database1 with table1.
database2 with table1_duplicate.

Manually move the data from database1 table1 by exporting that table's data either as a comma delimited file or as insert statements. Then go to database2 and import that file into table1_duplicate.

There are options for import and export functions under the Database menu option, Import or Export. Another way to export data would be to run a query in the Editor for the data and Save As a specific file format and import that file.

RESOLUTION #2
Another option would be to create a dump of database1 table1 and load that dump into the other database. More information about importing and exporting data can be found in the Help file.

In general there is no feature in Toad that automatically sets up a transfer of data from one database to another.

Other solutions to reference:
To export data please refer to solution #21734 https://support.quest.com/SUPPORT/index?page=solution&id=SOL21734
To import data please refer to solution #6394 https://support.quest.com/SUPPORT/index?page=solution&id=SOL6394