How to create a T-SQL value script

From dbscript Online Help
Jump to: navigation, search

Steps[edit]

  • Create a Project Version in the Project containing the schema information
  • 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
  • Press Generate, Download