Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleRestore and Backup Repositories

To restore and backup repositories refer to the official blog hereblog 

Newtablink
aliashere
urlhttps://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-a-full-database-backup-sql-server
.


Based on the source and destination you have two possibilities to migrate IDERA Dashboard repositories:

...

Since you are unable to connect to the Linux SQL Server, you need to perform the backup of the IDERA Dashboard repository on the Linux machine to restore it on the Windows machine. To achieve this, Microsoft provides sqlcmd command line tools to allow you to perform various actions. Find the installation instructions

Newtablink
aliashere
urlhttps://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools
.

Find the commands for backup and restore operations using sqlcmd

Newtablink
aliashere
urlhttps://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 above.
  9. Once successfully restored the repository, open IderaDashboardCoreServices.exe.config and update the "RepositoryHost"  to the SQL Server Windows Instance name.
  10. Start Idera Dashboard Core Services and Idera Dashboard Web Application Services.

...