Versions Compared

Old Version 44

changes.mady.by.user Daniela Villalobos

Saved on

compared with

New Version 45

changes.mady.by.user Daniela Villalobos

Saved on

Key

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

...

  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 process when the SQL Server Windows instance can connect to the SQL Server Linux instance.

    Follow the steps below to migrate the IDERA Dashboard Repository from a SQL Server Linux instance 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.
      • Connect to the SQL Server Linux instance from SQL Server Management Studio on Windows and identify the IDERA Dashboard repository you want to migrate.
      • Backup the IDERA Dashboard repository. This generates a .bak file in a specified folder.
      • Copy the .bak file from the Linux machine to the Windows machine where SQL Server Windows is installed.
      • Open SQL Server Management Studio and connect to the SQL Server Windows instance.
      • Perform a restore operation of the .bak file in the SQL Server Windows instance.
      • Once successfully restored the repository, 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.

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

    When connecting to the Linux SQL Server instance from Windows SQL Server Management Studio is not possible, you need to perform the backup of the IDERA Dashboard Repository on the Linux machine and restore it on the Windows machine. To achieve this, Microsoft provides sqlcmd command line tools. Find command line tools installation instructions
    Newtablink
    aliashere
    urlhttps://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup-tools
    .

Find the commands to backup and restore databases using sqlcmd

Newtablink
aliashere
urlhttps://docs.microsoft.com/en-us/sql/linux/sql-server-linux-backup-and-restore-database
.

...