|
Ispirer SQLWays Database Migration Software
Files Created for Importing to Microsoft SQL Server
When the target database is SQL Server, the following files are created by SQLWays while exporting and converting the source database:
SQL files contain SQL statements used for creating database structure (tables, stored procedures etc.) in SQL Server using the SQL Server ISQL utility.
Data files are ASCII files that contain data from tables in the text format. Each table has its own txt file.
SQLWays uses the SQL Server BCP utility to import data from data files (.txt) to SQL Server. Format files are used by BCP to define data file structure (field length, field terminals etc.).
Import scripts are command files used for importing the source database into SQL Server. Import scripts execute the ISQL utility for creating database structure and the BCP untility for importing data.