After creating a temporary ApsaraDB RDS for SQL Server instance and migrating data to it, log on to verify data accuracy before restoring the data to your destination instance.
Prerequisites
Before you begin, make sure that you have:
A temporary instance that is created.
Temporary instances are accessible over the internal network only. To connect, use a client or tool that runs within the same VPC as the temporary instance.
Method 1: Log on using DMS
Data Management Service (DMS) lets you log on directly from the RDS console without setting up an ECS instance.
DMS is free when your instance is managed in Flexible Management mode. The Stable Change and Security Collaboration modes generate fees and provide additional management capabilities.
Go to the Instances page. In the top navigation bar, select the region where the instance resides. Find the instance and click its ID.
Click Log On to Database.
In the Log on to Database Instance dialog box, configure the following parameters and click Login:
Access Mode: Select Account + password login.
Database Account and Database Password: Enter the account credentials. In this example, a privileged account named
testuseris used.Control Mode: Select Flexible Management.
In the left-side navigation pane of the DMS console, choose Database Instances > Instances Connected to view the connected database. In this example, the database
dbtestis displayed.
Method 2: Log on using SSMS on an ECS instance
Use SQL Server Management Studio (SSMS) on a Windows ECS instance to connect to the temporary instance over the internal network.
The ECS instance and the temporary RDS instance must be in the same region and the same VPC.
Create an ECS instance running Windows Server, if you do not already have one in the same VPC.
Add the internal IP address of the ECS instance to the whitelist of the temporary RDS instance.
Log on to the ECS instance and install the latest version of SSMS to support all SQL Server versions.
Open SSMS. In the Connect To Server dialog box, enter the following information and click Connect: After the connection is established, the instance appears in the left-side panel of SSMS.
Server Name: The internal endpoint and port of the temporary instance, separated by a comma — for example,
rm-2ze****.rds.aliyuncs.com,1433.Authentication: Select SQL Server Authentication.
Login: The username of the database account — for example,
testuser.Password: The password of the database account — for example,
Test_pw123.
What's next
After verifying data accuracy in the temporary instance, restore the data to the destination RDS instance.