SQL Packager - 6.4

SQL Packager

Generating a C# project - SQL Packager

Choosing a project type > Specifying contents > Previewing scripts > Specifying a package type > Running

When you have chosen the database, objects, and data that you want to package and previewed the SQL scripts, you can define the parameters for the C# project.

You should create a C# project if you want to customize the package. For example, you can edit the forms created in the project to customize the appearance of the graphical user interface that is displayed when you run the package.

To create a C# project:

  1. On the Specify package type page of the Packager Wizard, select Package as a C# project.

  2. Click Next.

  3. On the Create C# Project page, in the Name box, type a name for the project.

    If you create a package with a file name that already exists, SQL Packager automatically assigns a different file name for the package. For example, if SQLPackage exists, the default name for the new package is SQLPackage1. You can turn off this feature by using the packaging options.

  4. In the Location box, type or select the path for the project, or click Browse to choose the folder or create a new folder.

    You can change the default location by using the packaging options.

  5. If you want to add information to be seen when the package is run, or if you are creating a package for a new database and you want to specify the database properties, click Extra package info and enter the details as required.
  6. To compress the package, select Compress generated SQL resource files.

    The package is usually compressed to approximately 75% of its original size.

    Note that if you compress the package, you will not be able to add resource files to the project or edit the existing resource files.

  7. To open the project in Microsoft® Visual Studio® immediately, select the Open project in Visual Studio check box; to create the project without opening it, clear the check box.
  8. Click Finish.

    A message dialog box is displayed to confirm that the project has been created at the location you specified.

  9. Click OK to close the message dialog box.

    If you chose to open it immediately, SQL Packager launches the project in Visual Studio. For more information, see Running the package.

See also

Entering extra package information

Creating an .EXE

Previewing the SQL scripts

Running the package

Worked example: Packaging an upgrade as a C# project

Specifying the package contents

Was this article helpful?

Search support
Forums
Visit the SQL Packager forum.

SQL Packager

all SQL products

all products