SQL Packager - 6.4

SQL Packager

Working with projects - SQL Packager

Whenever you create a database package, you set up a project. A project contains:

  • the information required to connect to the database you want to package
  • information about which objects and data you want to include in the package
  • the package details such as name, location, type, and compression
  • optional deployment notes
  • optional details about the database that will be created, such as the default name and size

You can create a new project each time you create a package. Alternatively, if you will be using the same settings repeatedly, you can save the current project to a file. You can then open it at a later date to make it the current project. You can also edit the current project if required.

You are recommended to run the project using the default packaging options and review the results before you change any options. If you want to change your packaging options before you run the next project, if necessary click Cancel on the Packager Wizard, and set the options before you proceed.

Note that packaging options are not saved as part of the project.

Creating a new project

To create a new project:

  1. If the Packager Wizard is not already displayed, click  New Project. The Packager Wizard opens.

    If you have unsaved changes in the current project, you are prompted to save it.

  2. In the Packager Wizard, choose a project type.
  3. If you are not packaging an existing SQL script, specify the package contents.
  4. Review any generated SQL scripts for the object and data creation.
  5. Create an .EXE (.NET executable) or a C# project.

    SQL Packager packages the database. Alternatively, you can launch the package creation script in your default SQL editor, or save the script.

    You can then save the project if required.

Saving the current project

When you have packaged a database, you can save a new project so that you can re-use the settings at a later date, or you can save an existing project to a new name. Projects are saved with the extension .sqlpkg

  • On the File menu, click Save Project As.

    A standard Windows® Save As dialog box is displayed.

If you have edited the current project, an asterisk (*) is shown in the title bar; to save the edited project to the same name:

  • On the File menu, click Save Project; alternatively, click 

Editing the current project

You can edit the current project and package the database again.

  1. Click  Edit Project.
  2. In the Packager Wizard, change the package specification as required.
  3. Review the generated SQL scripts for the object and data creation.
  4. Generate an .EXE or a C# project.

    SQL Packager packages the database. An asterisk (*) is displayed in the title bar to indicate that the project has been edited.

Opening an existing project

  1. If the Packager Wizard is displayed, click Cancel to close it.
  2. Click  Open Project.

    If you have unsaved changes in the current project, you are prompted to save it.

  3. In the Open dialog box, choose the project and click Open.

    The Packager Wizard is displayed with the project's settings.

To open a recently-used project, on the File menu, click the name of the project.

See also

Specifying the package contents

Previewing the SQL scripts

Creating a C# project

Creating an .EXE

Setting packaging options

Was this article helpful?

Search support
Forums
Visit the SQL Packager forum.
Learning SQL Packager
Knowledge base

SQL Packager

all SQL products

all products

Notes & articles

SQL Packager

all SQL products

all products

Demos & walkthroughs

SQL Packager