百度智能云

All Product Document

          Relational Database Service

          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.

          Previous
          Cloud Migration on PostgreSQL
          Next
          Cloud Migration on MySQL Database