3.8 Migrate IDERA Dashboard Repositories

To migrate repositories there can be 2 scenarios based on the souce and destination SQL Server instances.

 

Scenario 1 : The source and destination instances are connected to each other over the network

 

That is, using SQL Server Management studio on the windows SQL Server instance you can connect to the SQL Server Linux instance. In such cases, the entire migration between instances can be achieved using the Windows SQL Server Management Studio.

 

Following are steps to migrate. The assumption for the steps is that Idera Dashboard repository is present in the SQL Server Linux instance and you need to migrate to the SQL Server Windows instance. The same steps can be applied to migrate the other way around as well.

1. Stop Idera Core Services and Idera Web Application services
2. Open SQL Server Management studio
3. Connect to the SQL Server Linux instance from SQL Server Management studio
4. Identify the Idera Dashboard repository to be migrated.
5. Take a backup of the Idera Dashboard repository from the steps mentioned in the blog above. This will generate a .bak file in the specified directory
6. Log into the Linux machine and copy the .bak file
7. Log back into the Windows machine where SQL Server Windows is present and paste in any desired location
8. Open SQL Server Management studio and connect to the SQL Server Windows instance
9. Perform a restore of the bak file to the SQL Server Windows instance
10. Once successfully restored the repository, open IderaDashboardCoreServices.exe.config
11. Update the "RepositoryHost"  to the SQL Server Windows Instance name
12. Start Idera Dashboard Core Services and Idera Dashboard Web Application Services

 

 

Scenario 2 : The source and destination instances are not connected to each other over the network

 

That is, using Windows SQL Server Management studio you are unable to connect to the SQL Server on Linux instance

 

Since you are unable to connect to the Linux Sql Server, you will now need to perform a backup on the linux machine itself before you can restore on the windows machine. To achieve this Microsoft provides sqlcmd command line tools to allows you to perform various capabilities.

 

Installation and usage of the tools can be found here : https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools

 

Commands for backup and restore using sqlcmd can be found here : https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-backup-and-restore-database

 

1. Stop Idera Core Services and Idera Web Application services
2. Log into the Linux machine
3. Connect to the SQL Server Linux instance
4. Identify and take backup of the repository using the sqlcmd commands
5. Copy the .bak file
6. Log in to SQL Server Windows Instance machine and paste the .bak file to any desired directory
7. Open SQL Server Management Studio and connect to the windows instance
8. Perform the restore of the .bak file as mentioned in the blog : https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server
9. Once successfully restored the repository, open IderaDashboardCoreServices.exe.config
10. Update the "RepositoryHost"  to the SQL Server Windows Instance name
11. Start Idera Dashboard Core Services and Idera Dashboard Web Application Services

 

For restoring the repository on Linux, follow similar steps as above, but take a backup of repository using SQL Server Management studio, copy .bak file to the Linux machine and perform a restore using sqlcmd command.