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 SQL Packager Wizard, and set the options before you proceed.

To create a new project:

1. If the SQL 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 SQL 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.