Moving repository between SQL Servers

The easiest way to move the Dataedo repository from one server instance to another would be 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 Dataedo Administration Console after the transfer.

Screenshots below are from SQL Severer Managment Studio 2016 - previous versions may look slightly different, so if you run into any issues, do contact us at support@dataedo.com

1. Log in to your SQL Server instance through Management Studio.
2. In Object explorer, find and right click your repository database.
3. From the context menu, choose Task > Export Data-tier Application...
4. On the introduction screen, click Next.
5. On the Export Settings screen, in the Settings tab, choose Save to local disk and click Browse... then specify location and name of the export file.
6. Connect to the other server instance to which you want to transfer your repository.
7. Right click the Databases folder.
8. From the context menu, choose Task > Import Data-tier Application...
9. On the Introduction page, click Next.
10. On the Import settings screen, choose Import from local disk, and click Browse... and point to the file you've exported previously. Click Next.
11. On Database Settings screen, in the New database name field specify the name of your new repository database.
12. On Summary screen, click Finish.
13. After a while, your database will be created.
14. Connect to the new database with Dataedo Administration Console to recreate user and license information.

You should be ready to go now.