Cloud Migration on SQL-Server
Introduction
RDS provides online and offline data migration modes for the SQL Server database. In online mode, migrating the database gets done through the console. The user can complete the online migration of the database without the need to stop the server, and this feature supports the database migration on later versions from SQL Server 2008. In offline data migration mode, the users need to provide a full backup packet. Then, the user can recover the database to the RDS by offline means.
Notices on Offline Migration
Before the backing-up, change the database mode from recovery mode to complete mode.
Offline Migration Process
The users back up the corresponding database using SQL command.
USE master
BACKUP DATABASE dbname1 TO DISK ='D:\dbname1.bak' with INIT;
BACKUP LOG dbname1 TO DISK ='D:\dbname1.bak' WITH NOINIT;
GO
Upload the "bak" backup packet to the address for downloading, and offer it to the Customer Service staff. After that, offline migration begins.