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.