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