Move the ThinScale DB from one server to another

This article will outline how you can move the ThinScale DB from one SQL Server to another one. #MC-KB10

Written by Giuseppe

Last published at: July 28th, 2022

In this article, we will show how a Database administrator can easily move the ThinScale Db from one SQL Server to another one.

It is always advisable to have a backup of the Database you are trying to migrate, and ThinScale doesn't take any responsibilities for 

any data that can be potentially be lost while following this tutorial.

Microsoft SQL Server Management Studio access must be required to perform these tasks.

1 - Connect to your desired Database Engine, with an SQL Authentication or Windows Authentication and click Connect.

2 - Choose the Database you want to migrate or copy over to a different Server and chose Tasks.

3 - Select "Export Data" to migrate the db directly to a new Server.

4 - The Import and Export wizard will appear.

5 - Follow the instruction, use the Data Source "Microsoft OLE DB Provider for SQL Server".

6 -  Choose Copy data from one or more tables or views

7 - Select the entire source

8 -  Choose Run immediately 

9 -  Let that finish 

10 - From a Database point of view you are done.

11 - The missing step is to modify the Server Database Name / Instance destination in the ThinScale Server Configuration Management from the old server to the new one.