Schema import with SSMS - wiltondb/wiltondb GitHub Wiki
On this page:
Prerequisites
AdventureWorks sample DB
We will use AdventureWorks sample database.
Follow the instructions to restore the AdventureWorks20xx.bak
:
Export schema to SQL file
In SSMS right click the restored AdventureWorks20xx database and choose: "Tasks" -> "Generate Scripts ...":
Choose "Save as script file":
Press "Advanced" button and check the "Schema only" option is selected:
Run the export:
Resulting SQL file aw_schema.sql
is written with size 1.12 MB.
Import schema into WiltonDB
In this example we assume that MSSQL is running locally on port 1433.
Install WiltonDB on the same machine, change its TDS port to 7433
and open the connection to it from SSMS:
Open "New Query" for WiltonDB connection, open aw_schema.sql
and run it:
Multiple error messages are generated for schema details not supported in WiltonDB. In case of AdventureWorks ALTER DATABASE
and other errors do not prevent the majority of the schema and T-SQL stored procedures to be imported. Running this step on a database schema for your applications it makes sense to inspect the errors carefully and adjust the schema SQL file where possible. Babelfish Compass tool can be used to generate the report for schema file and rewrite some of unsupported SQL statements.
Next: Data import with sqlcmd