Exporting as BAK

To save changes that have been made while working with your published database to a local computer, you can use the export feature. This feature will export modified databases as BAK, preserving all the changes that have been made during the publishing session.

To export a published database, do the following:

1. In the navigation pane, under the Published databases node, select a published database.
2. On the Publish tab, select Export backup or you can right-click a database and select Export backup.

3. In the Export wizard, click Browse next to the Specify export path field to specify the location where to export your data.

To compress data, select the Enable compression check box. Compression will be applied according to configuration of the SQL server to which the database is published.