You can create a temporary instance, restore data to the temporary instance, log on to the temporary instance to check whether the data is correct, and restore the data from the temporary instance to the destination instance. This topic describes how to log on to a temporary instance.

Prerequisites

The instance version must be ApsaraDB RDS SQL Server 2012/2016 Basic Edition or ApsaraDB RDS SQL Server 2008 R2 High-availability Edition.

Log on to a temporary instance

You can log on to temporary instances through the intranet. The intranet is fast, secure, and free of traffic fees within the network.

Log on to an instance through the ECS client

  1. Create an ECS instance to access the ApsaraDB for RDS temporary instance. The ECS instance must meet the following requirements:
    • The ECS instance and RDS instance must reside in the same region.
    • The network type must be classic network. This is because ECS and RDS instances must have the same network type for communication over the intranet and the network type of all RDS temporary instances is classic network.
  2. Add the intranet IP address of the ECS instance to the whitelist of the RDS temporary instance.
  3. Log on to the ECS instance. For more information, see Overview.
  4. Access the RDS temporary instance from the ECS instance. For more information, see the "Use a client to connect to an instance" section in Connect to an RDS SQL Server instance.