Back to Working With ShiftSchema
ScriptGen is a command line application that examines two sets of database schema
information and generates a DDL script to synchronize the two.
The purpose of ScriptGen is to create change scripts for moving a QA or Production
database from one version of your application to another.
Warning: ScriptGen does not consider factors such as table and index partitioning
options or database security. It also does not guarantee to maintain the data in
modified tables. As such you should examine the DDL scripts created by ScriptGen
with extreme care before executing them in a production environment and to remember
to always take a backup of your database before making any changes.
Usage: ScriptGen.exe <Options> <OutputPath>
Options:
|
SrcProvider=value
|
Type of source provider. Valid values are FileSystem or MSSQL
|
|
SrcWC=value
|
Path of the source working copy. Only valid when SrcProvider=FileSystem.
|
|
SrcServer=value
|
Name of the source database server. Only valid when SrcProvider=MSSQL
|
|
SrcDatabase=value
|
Name of the source database. Only valid when SrcProvider=MSSQL
|
|
SrcUsername=value
|
Username used to access the source database. Only valid when SrcProvider=MSSQL
|
|
SrcPassword=value
|
Password used to access the source database. Only valid when SrcProvider=MSSQL
|
|
SrcUseWindowsAuth
|
Indicates the database uses windows authentication. Only valid when SrcProvider=MSSQL
|
|
DstProvider=value
|
Type of destination provider. Valid values are FileSystem or MSSQL. If this is not
specified scripts to create the entire database will be generated.
|
|
DstWC=value
|
Path of the destination working copy. Only valid when DstProvider=FileSystem.
|
|
DstServer=value
|
Name of the destination database server. Only valid when DstProvider=MSSQL
|
|
DstDatabase=value
|
Name of the destination database. Only valid when DstProvider=MSSQL
|
|
DstUsername=value
|
Username used to access the destination database. Only valid when DstProvider=MSSQL
|
|
DstPassword=value
|
Password used to access the destination database. Only valid when DstProvider=MSSQL
|
|
DstUseWindowsAuth
|
Indicates the database uses windows authentication. Only valid when DstProvider=MSSQL
|
OutputPath:
This is the name of the DDL script to create.
Back to Working With ShiftSchema