How to create a T-SQL value script
Steps
- Create a Project
- Create a Project Version in the Project containing the schema information
- Create a Value Script
- Enter an ID, select script type T-SQL, press Create
- In the Value Script menu, select Tables
- Add the table names to be scripted
- If a table depends on existing values of another table, make sure the Sequence property is set correctly
- For each table, define the Primary Key column
- For each table, select the column names to be scripted
- In the Value Script menu, select Generate Script
- Press Generate, Download
