Skip to main content

Moving repository between SQL Servers

The easiest way to move the Dataedo repository from one server instance to another is to create a BACPAC file and import it.

Please note that this may not move user/license data, so you'll probably need to define users again through the Dataedo Administration Console after the transfer.

Screenshots below are from SQL Server Management Studio 2016 - previous versions may look slightly different, so if you run into any issues, contact us at [email protected]

  1. Log in to your SQL Server instance through Management Studio.

  2. In Object Explorer, find and right-click your repository database.

Object Explorer
  1. From the context menu, choose Task > Export Data-tier Application...
Export Data-tier Application

  1. On the introduction screen, click Next.

  2. On the Export Settings screen, in the Settings tab, choose Save to local disk and click Browse... then specify the location and name of the export file.

Export Settings

  1. Connect to the other server instance to which you want to transfer your repository.

  2. Right-click the Databases folder.

  3. From the context menu, choose Task > Import Data-tier Application...

Import Data-tier Application

  1. On the Introduction page, click Next.

  2. On the Import settings screen, choose Import from local disk, and click Browse... and point to the file you've exported previously. Click Next.

Import Settings
  1. On the Database Settings screen, in the New database name field, specify the name of your new repository database.
Database Settings

  1. On the Summary screen, click Finish.

  2. After a while, your database will be created.

  3. Connect to the new database with the Dataedo Administration Console to recreate user and license information.

You should be ready to go now.