To create a package:

1. Create schema and data scripts for packaging using the SQL Compare and SQL Data Compare command lines. For more information, see:
   • /empty2 (SQL Compare documentation)
   • /empty2 (SQL Data Compare documentation)
   • MissingFrom2AsInclude (SQL Data Compare documentation)
     

2. Open a Command Prompt window in the folder where you installed SQL Packager 8. 

   To do this, navigate to the folder, then hold Shift, right-click and select Open command window here. 

   Alternatively, open a Command Prompt window anywhere and change directory to the folder where you installed SQL Packager 8. For example:

   cd "C:\Program Files (x86)\Red Gate\SQL Packager 8"

3. At the command prompt, type sqlpackager.

4. Specify the paths of the scripts you want to package, and a name and location for the package, and press Enter.
   The package is created in the specified location.

Example

To package the schema and data of database WidgetSales as WidgetSalesUpgrade.exe in C:\Packages: 

sqlpackager /schemascript:"C:\Scripts\WidgetSalesSchema.sql" /datascript:"C:\Scripts\WidgetSalesData.sql" /outputfolder:"C:\Packages" /name:WidgetSalesUpgrade.exe

Switches

/schemascript:<file path(s)>

The path of the schema script you want to package. You must specify either /schemascript or /datascript. You can specify multiple paths as a comma-separated list. 

/datascript:<file path(s)>

The path of the data script you want to package. You must specify either /schemascript or /datascript. You can specify multiple paths as a comma-separated list.

/name:<name of executable> (optional)

The name of the package that will be created. You don't have to append .exe onto the file name. If you don't specify a name, the current date and time will be used, eg package-2014-11-13-1137.exe.

/outputfolder:<folder path> (optional)

The folder where the package will be created. If you don't specify a folder, the package will be created in the current folder.

/force (optional)

Overwrites any existing package in the output folder that has the same name as the new package.