Deployment Manager 2

Publishing database packages from SSMS

You can use the SQL Server Management Studio Deployment Manager add-in to create and publish database packages from SQL Server Management Studio. If you have SQL Source Control 3.5.5 or later, you can publish a database revision from source control.

You can then use Deployment Manager to deploy database packages to target SQL servers.

For information about database packages, see Packaging databases.

Publishing a database package

  1. In the SSMS Object Explorer, right-click the database you want to package and click Publish for deployment:


    The Deployment Manager Database Publisher opens:
     

  2. On the Deployment Manager Details page, specify the URL for your Deployment Manager server (the URL you use to view the web interface, eg DMServer.exampe.com), and the API key for your user account, and click Next.
    The Source page is displayed:

  3. To publish a package from the live database, select Database and click Next.
    Alternatively, to publish a package from a database revision in source control, select SQL Source Control
    The latest revision is selected by default. To select an older revision, click Choose revision.
    The SQL Source Control History dialog box opens:

    Select the database revision you want to publish and click Select.
    On the Source page, click Next.

    For more information about the History dialog box, see Viewing source control history in the SQL Source Control documentation.

  4. On the Package Details page, specify a name and version number for the package you want to create:

  5. Under Package feed to publish to, select from the list feeds added to Deployment Manager.

    For more information, see Working with package feeds.

  6. Click Next.
    The Static Data page is displayed:
  7. Select any tables you want to include as static data. The data in these tables will be included in the package.

    If you selected a revision from source control in step 3, you can't select static data here. Instead, Deployment Manager will publish any static data in the database revision.

    For more information about static data, see Static data in the SQL Source Control 3 documentation.

  8. Click Publish.
    When the package has been successfully published, the Publish Database Package page is displayed:


Deploying a package with Deployment Manager

After you've published a database package, you can deploy it using the Deployment Manager web interface or command line. For more information, see Deploying database packages.


Didn't find what you were looking for?