How to migrate databases from one SQL server to another (Versions 7.x – 8.x) (SL4299)

The information in this article applies to:

Desktop Authority 7.x – 8.x 

HOW TO: 

Move databases from one SQL server to another 

Follow the steps below to move the Desktop Authority Databases to a new SQL Server.

Backup the "DAConfiguration" database on the current SQL server

1. Open the Desktop Authority Manager

2. Select Global Options from the Navigation Pane

3. Select Server Manager

4. On the View Pane, select the Database Configuration Tab

5. Click on the ellipsis radio button (…)

• On the SQL/MSDE Server Explorer window, select the server from the drop-down menu list

• Click OK

1. Click on Connect

2. Select the DAConfiguration database from the Database drop-down menu list

3. On the Database Operations drop-down menu list, select Perform a Backup or Restoration

4. Click to select the Perform a backup radio button

5. On the Backup File line, click to select the ellipsis radio button (…)

• Browse to the folder where the database will be saved

• Name the file DAConfiguration (The file will automatically be given a .BAK file extension)

• Click on Open

• Note the path and file name

1. Click on Backup Database 

Backup the DAReporting database on the current SQL server

1. Open The Desktop Authority Manager

2. Select Global Options from the Navigation Pane

3. Select Server Manager

4. On the View Pane, select the Database Configuration Tab

5. Click on the ellipsis radio button (…)

• On the SQL/MSDE Server Explorer window, select the server from the drop-down menu list

• Click OK

1. Click on Connect

2. Select the DAReporting database from the Database drop-down menu list

3. On the Database Operations drop-down menu list, select Perform a Backup or Restoration

4. Click to select the Perform a backup radio button

5. On the Backup File line, click to select the ellipsis radio button (…)

• Browse to the folder where the database will be saved

• Name the file DAReporting (The file will automatically be given a .BAK file extension)

• Click on Open

• Note the path and file name

1. Click on Backup Database 

Replace the old SQL server name with the new SQL server name

1. Open the Desktop Authority Manager

2. Select File | Edit Global System Settings

3. On the Global System Settings window

1. Under Reporting SQL Settings

• Replace the old SQL Server name with the new SQL Server name

2. Under Configuration SQL Settings

• Replace the old SQL Server name with the new SQL Server name

3. Click OK
   
   
   
   

4. Select File

5. Select Save Changes

Restore databases for Desktop Authority 7.x & 8.x versions:

Restore the DAConfiguration database to the new SQL server

1. Open the Desktop Authority Manager

2. Select Global Options from the Navigation Pane

3. Select Server Manager

4. On the View Pane, select the Database Configuration Tab

5. Click on the ellipsis radio button (…)

• On the SQL/MSDE Server Explorer window, select the server from the drop-down menu list

• Click OK

6. Click on Connect

7. Select the DAConfiguration database from the Database drop-down menu list

8. On the Database Operations drop-down menu list, select Perform a Backup or Restoration

9. Click to select the Perform a restore radio button

10. On the Restore File line, click to select the ellipsis radio button (…)

• Browse to the folder where the database was saved

• Select the file DAConfiguration.BAK

• Click on Open

11. Click on Restore Database 

Restore the DAReporting database to the new SQL server

1. Open the Desktop Authority Manager

2. Select Global Options from the Navigation Pane

3. Select Server Manager

4. On the View Pane, select the Database Configuration Tab

5. Click on the ellipsis radio button (…)

• On the SQL/MSDE Server Explorer window, select the server from the drop-down menu list

• Click OK

6. Click on Connect

7. Select the DAReporting database from the Database drop-down menu list

8. On the Database Operations drop-down menu list, select Perform a Backup or Restoration

9. Click to select the Perform a restore radio button

10. On the Restore File line, click to select the ellipsis radio button (…)

• Browse to the folder where the database was saved

• Select the file DAReporting.BAK

• Click on Open

11. Click on Restore Database