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.
To restore and backup repositories, refer here. |
Based on the source and destination you have two possibilities to migrate IDERA Dashboard repositories:
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.
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
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.