Microsoft SQL Server counts with a mechanism to backup and restore repositories. This mechanism is also used to migrate repositories between instances. You can make use of this mechanism to migrate the IDERA Dashboard repositories between SQL Server Windows and SQL Server Linux instances.
Restore and Backup Repositories
To restore and backup repositories refer to the official blog here.
Based on the source and destination you have two possibilities to migrate IDERA Dashboard repositories:
The source and destination instances are connected to each other over the network
SQL Server Management Studio on the windows SQL Server instance 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.
- Stop Idera Core Services and Idera Web Application Services.
- Open SQL Server Management studio.
- Connect to the SQL Server Linux instance from SQL Server Management studio on Windows.
- Identify the IDERA Dashboard repository to be migrated.
- Take a backup of the IDERA Dashboard repository. This will generate a .bak file in the specified directory.
- Log into the Linux machine and copy the .bak file.
- Log back into the Windows machine where SQL Server Windows is present and paste in any desired location.
- Open SQL Server Management studio and connect to the SQL Server Windows instance.
- Perform a restore of the .bak file to the SQL Server Windows instance.
- Once successfully restored the repository, open IderaDashboardCoreServices.exe.config and update the "RepositoryHost" to the SQL Server Windows Instance name.
- Finally start Idera Dashboard Core Services and Idera Dashboard Web Application Services.
The source and destination instances are not connected to each other over the network
Windows SQL Server Management studio is 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.
Command line tools on Linux
Installation and usage of the tools can be found here.
Commands to backup and restore
Commands for backup and restore using sqlcmd can be found here.
- Stop Idera Core Services and Idera Web Application services
- Log into the Linux machine
- Connect to the SQL Server Linux instance
- Identify and take backup of the repository using the sqlcmd commands
- Copy the .bak file
- Log in to SQL Server Windows Instance machine and paste the .bak file to any desired directory
- Open SQL Server Management Studio and connect to the windows instance
- 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
- Once successfully restored the repository, open IderaDashboardCoreServices.exe.config
- Update the "RepositoryHost" to the SQL Server Windows Instance name
- 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.