Database export/import tool from one DB to another DB

[xbotuk]

Database export/import tool from one DB to another DB

[gerdwagner]

Here are some features SQuirreL offers to copy data from one DB to another:

1. Select tables in SQuirreL's Object tree and choose "Copy table" from the right mouse menu. Then go to another Session's Object tree and choose "Paste table" on your preferred destination schema/table type node.
2. Select tables in SQuirreL's Object tree and use the "Scripts" submenus to script table DDLs and data insert statements. This method is suitable for a limited amounts of data only.
3. SQL results can be exported using the right mouse menu either on the result tables or on the SQL statement. (For information on advanced exporting methods click the "About exporting link ..." at the bottom of the export dialog.)
   To import the exported data into another database use the import menu in the Object tree's right mouse menu.

[gerdwagner]

The latest snapshot available here
https://github.com/squirrel-sql-client/squirrel-sql-snapshot-releases/releases/tag/snapshot-20231004_0026
or here
https://sourceforge.net/projects/squirrel-sql/files/3-snapshots/snapshot-20231004_0026/
offers two more exporting options, see the following excerpt from our change log:

Object tree: New right mouse menus in "Scripts" submenu:
"Store selected tables' data in files" and "Create INSERT statements file from selected tables"

A function to import data of several formats is available in the Object tree's right mouse menu or the menu
Session --> "File import".