Page History
...
Following are steps to migrate repositories. 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. Apply the same steps the other way around as well.
...
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.:
| Info | ||
|---|---|---|
| ||
Installation Find the installation and usage of the tools can be found here. |
| Info | ||
|---|---|---|
| ||
Commands for backup and restore using sqlcmd can be found are 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-serverabove.
- Once successfully restored the repository, open IderaDashboardCoreServices.exe.config Update and 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 commandcommands.
| Scroll pdf ignore | ||
|---|---|---|
|