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

Step 2 of 5. MS SQL script file settings

If "Export into local T-SQL script file" option has been selected, this wizard page allows to specify how to create the resulting script file. There are following settings available:
  • Insert 'CREATE DATABASE' statement - select this option to put 'CREATE DATABASE' statement in the resulting dump file. This setting doesn't take effect without the option below activated.
  • Insert 'CREATE TABLE' statements - select this option to put 'CREATE TABLE' statements in the resulting dump file. You should always select it in order to obtain a valid dump file. The only exception is appending the data to existing tables.
  • Insert comments - select this option to add brief comments. It makes the resulting dump file more readable.

Have questions? Contact us