Versions Compared

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 instanceInstance.

    Follow the steps below to migrate the IDERA Dashboard Repository from a SQL Server Linux instance Instance to a SQL Server Windows instanceInstance. Apply the same steps the other way around as well.


    1. Stop Idera Core Services and Idera Web Application Services on the SQL Server Windows Instance.
    2. Open SQL Server Management Studio.
    3. Connect to the SQL Server Linux instance Instance from SQL Server Management Studio on Windows and identify the IDERA Dashboard repository you want to migrate.
    4. Backup the IDERA Dashboard repository. This generates a .bak file in a specified folder.
    5. Copy the .bak file from the Linux machine to the Windows machine where SQL Server Windows is installed.
    6. Open SQL Server Management Studio and connect to the SQL Server Windows instanceInstance.
    7. Perform a restore operation of the .bak file in the SQL Server Windows instanceInstance.
    8. Once successfully restored the repository, open IderaDashboardCoreServices.exe.config and add RepositoryHost  to the SQL Server Windows Instance name.
    9. 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. 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 instance machine and paste the .bak file to any desired directory.
    7. Open SQL Server Management Studio and connect to the windows 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 add the RepositoryHost to the SQL Server Windows Instance name.
    10. Start Idera Dashboard Core Services and Idera Dashboard Web Application Services.

...