From:       To:      
Home > Documentation > Convert Access to SQL Server > Tutorial

Step 1 of 5. Select Conversion Mode

Specify how Access to MS SQL migration tool should convert the source database. The database converter provides two options of migrating from MS Access to SQL Server:
  • Migrate to MS SQL server directly - use this option to migrate Microsoft Access database to the target SQL Server directly. MS SQL server must be launched and the user must have sufficient privileges to write into database. See Connect to SQL Server article for related information.
  • Export into local T-SQL script file - use this option to export MS Access database into a local SQL script file instead of moving it to SQL Server directly. The script file contains T-SQL statements to create tables (along with indexes and constraints) and to populate them with the data. See Importing T-SQL script file article for related information.

Have questions? Contact us