Page History

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

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

   You can use Windows SQL Server Management Studio for the entire migration

...

1. process when the SQL Server Windows

...

1. instance can connect to the SQL Server Linux instance.

...

1. Follow the steps below to migrate

...

1. the

...

1. IDERA Dashboard

...

1. Repository from a SQL Server Linux instance

...

1. to a SQL Server Windows instance. Apply the same steps the other way around as well.

   • • Stop Idera Core Services and Idera Web Application Services on Windows Services Manager.
     • Open SQL Server Management
   studio
   • • Studio.
     • Connect to the SQL Server Linux instance from SQL Server Management
   studio
   • • Studio on Windows
   .Identify
   • • and identify the IDERA Dashboard repository you want to
   be migrated
   • • migrate.
   Take a backup of
   • • Back up the IDERA Dashboard repository. This
   will generate
   • • generates a .bak file in
   the
   • • a specified
   directory
   • • folder.
   Log into the Linux machine and copy
   • • Copy the .bak file
   .Log back into
   • • from the Linux machine to the Windows machine where SQL Server Windows is
   present and paste in any desired location
   • • installed.
     • Open SQL Server Management
   studio
   • • Studio and connect to the SQL Server Windows instance.
     • Perform a restore operation of the .bak file
   to
   • • in the SQL Server Windows instance.
     • Once successfully restored the repository,
   open IderaDashboardCoreServices.exe.config and update the "RepositoryHost"  to
   • • go to the CoreService folder (i.e. "C:\Program Files\Idera\Dashboard\CoreService").
     • Open IderaDashboardCoreServices.exe, change the value of the setting RepositoryHost for the SQL Server Windows Instance name, and save the changes.
   Finally start
   • • Start Idera Dashboard Core Services and Idera Dashboard Web Application Services.

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

...

1. When connecting to the Linux SQL Server

...

1. instance from Windows SQL Server Management Studio is not possible, you need to perform

...

1. the backup of the IDERA Dashboard Repository on the Linux machine

...

1. and restore it on the

...

1. Windows machine. To achieve this, Microsoft provides sqlcmd command line tools

...

1. . Find command line tools installation instructions

   Newtablink
   alias here url https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools

   .

Find the commands to backup and restore databases using sqlcmd

Follow the steps below to perform the repository migration:

• • • Stop Idera Core Services and Idera Web Application

...

• • • Services on Windows Services Manager.
    • Log into the Linux machine.
    • Connect to the SQL Server Linux instance.
    • Identify and

...

• • • backup

...

• • • the

...

• • • IDERA Dashboard 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 operation of the .bak file as mentioned

...

• • • Newtablink
      alias here url https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-database-to-a-new-location-sql-server

      .
    • After the restore operation is complete, go to the CoreService folder (i.e. "C:\Program Files\Idera\Dashboard\CoreService").
    • Open IderaDashboardCoreServices.exe, change the value of the setting RepositoryHost for the SQL Server Windows instance name and save the changes.
    • Start Idera Dashboard Core Services and Idera Dashboard Web Application Services.

...

To restore the IDERA Dashboard Repository on Linux, you can use SQL Server Management Studio to create a backup of the IDERA Dashboard Repository, then copy the .bak file to the Linux machine, and perform a restore operation using sqlcmd commands.