Versions Compared

Old Version 8

changes.mady.by.user Daniela Villalobos

Saved on

compared with

New Version 9

changes.mady.by.user Daniela Villalobos

Saved on

Key

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

...

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

That is, using SQL Server Management studio Studio on the windows SQL Server instance you can connect to the SQL Server Linux instance. In such cases, the entire migration between instances can be achieved using the Windows SQL Server Management Studio.

Following are steps to migrate. The assumption for the steps is that Idera IDERA Dashboard repository is present in the SQL Server Linux instance and you need to migrate to the SQL Server Windows instance. The same steps can be applied to migrate the other way around as well.

  1. Stop Idera Core Services and Idera Web Application servicesServices.
  2. Open SQL Server Management studio.
  3. Connect to the SQL Server Linux instance from SQL Server Management studio on Windows.
  4. Identify the Idera IDERA Dashboard repository to be migrated.
  5. Take a backup of the Idera IDERA Dashboard repository from the steps mentioned in the blog above. This will generate a .bak file in the specified directory.
  6. Log into the Linux machine and copy the .bak file.
  7. Log back into the Windows machine where SQL Server Windows is present and paste in any desired location.
  8. Open SQL Server Management studio and connect to the SQL Server Windows instance.
  9. Perform a restore of the .bak file to the SQL Server Windows instance.
  10. Once successfully restored the repository, open IderaDashboardCoreServices.exe.config Update and update the "RepositoryHost"  to the SQL Server Windows Instance name.
  11. Start Finally start Idera Dashboard Core Services and Idera Dashboard Web Application Services.



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

That is, using Windows SQL Server Management studio you are is unable to connect to the SQL Server on Linux instance.

Since you are unable to connect to the Linux Sql SQL Server, you will now need to perform a backup on the linux 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.

...