Difference between revisions of "How to create a T-SQL value script"
(New page: === 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-SQ...) |
|||
| Line 19: | Line 19: | ||
* For each table, select the column names to be scripted | * For each table, select the column names to be scripted | ||
| − | * In the Value Script menu, select Generate Script | + | * In the Value Script menu, select [[Script Generation|Generate Script]] |
* Press Generate, Download | * Press Generate, Download | ||
Revision as of 02:01, 6 November 2008
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
