Exporting Data

WinSQL offers several ways to move data from once source to another. For example, you can:

·Copy contents of one table to another table in a different database

·Export data from table to a text file

·Import data from a text file to a database

·Generate INSERT INTO statements for an existing data. These INSERT statements can later be run against an empty table to insert data rows.

This section talks about different ways of importing and exporting data from one source to another target in WinSQL.

Export templates

Beginning with WinSQL Professional version 2.0, you can create export templates files to use at a later date. Additionally, these files are needed if you wish to run the export routines from a command line.