Promote

Create Databases That Do Not Exist in the Destination

The compare process identifies the databases that do not exist on the destination system based on the Structure Data and SQL Objects. Promote has a feature that allows users to create databases that are not in the destination system. This process must be performed before SQL objects can be transported.

NOTE: Using Promote to create databases that do not exist on the destination server may not be permitted by all projects. This task may need to be performed by a database administrator.

To create a database on the destination system:

  1. Click Packages in the Navigation pane.

  2. Click the Packages icon for a package group.

  3. Click the Databases icon.

  4. Click the Create icon for the Database.