Moving Dataedo repository

At some point, you may need to move your repository between different SQL Server instances.

Here are tips on how to do it.

Moving to a newer or equal SQL Server version

Since the Dataedo repository is just an SQL Server database, moving it from an older to a newer version is easy. To do so, use Backup and Restore options.

Backup:

1. Expand the Databases folder.
2. Right-click on the selected database.
3. Go to Tasks -> Backup.
4. In the Database dropdown list, choose the database you want to backup.
5. In Backup type, choose Full backup type.
6. Choose the destination path.
7. Click OK to start the backup.
8. Depending on how big your database is, the backup process may take some time.

Restore:

1. Move the backup file to a location accessible from the new server.
2. Connect to the new server with SSMS.
3. Right-click on the Databases folder -> Restore Database.
4. In Source, choose Device.
5. Click on the button with three dots and select the Add button from the new window.
6. Find the backup file created previously, click OK, and again OK in the other window.
7. If you restore your database to a server where there is already a database with the same name, and you don’t want to overwrite it, then:
   • Change the restored database in the Database field.
   • Go to Files near the Select a page window.
   • Under the Restore As field, change names in Data and Log rows.
   • Save and click OK.

Moving to an older SQL Server version

The backup and restore method most likely won’t work in this case, so migrating using scripts is the safer solution.

1. Export scripts using this guide: how to migrate a SQL Server database to a lower version. I've used settings from the attached screenshot.

2. Correct the paths for database files in the script, or create the database manually and remove the relevant part of the script.
3. If you want to change the database name during migration, make sure to replace all mentions of the old name with the new one.
4. Connect to the new server and run the scripts.
5. To make sure users have correct licensing data, you'll need to remove and then add licenses for all users.
6. First, open Dataedo Administration Console. You can find a general guide for its use here: managing users.
7. Connect to your new repository.
8. To remove a license from a user, double-click a user with the Is Dataedo User column checked.
9. In the User details window, uncheck the Is Dataedo user box and click save.
10. Repeat this for all users.
11. To add a license to an existing database user, double-click it.
12. In the User details window, check the Is Dataedo user box, select the Key radio button, and paste your license key into the box below. Click Save.
13. Connect to the new repository with Dataedo to check if everything worked.