ApsaraDB RDS:Connect Kingdee K/3 WISE to an ApsaraDB RDS for SQL Server instance

Step 1: Upload a full backup file to an OSS bucket

1. Log on to the OSS console.

2. In the left-side navigation pane, click Buckets, then click Create Bucket.

3. Configure the following parameters, keep all other parameters at their defaults, and click OK.

   For more information about bucket creation, see Create buckets.

   Parameter	Value
   Bucket Name	Enter a name for the bucket.
   Region	Select the same region as your ECS instance and RDS instance.
   Storage Class	IA
   Redundancy Type	LRS
   ACL	Private
   Versioning	Off
   Encryption Method	None
   Real-time Log Query	Not Activated

4. In the left-side navigation pane, click Buckets, then click the bucket you just created.

5. Choose Object Management > Objects, then click Upload Object.

6. Drag the full backup file to the Files to Upload area, or click Select Files and choose the file.

   For more information, see Upload objects.

   

Step 2: Create a privileged account for the RDS instance

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region of your RDS instance, then click the instance ID.

2. In the left-side navigation pane, click Accounts.

3. Click Create Account and configure the following parameters.

   Parameter	Description
   Database Account	Enter an account name: up to 50 characters, using lowercase letters, digits, and underscores (_). Must start with a lowercase letter and end with a lowercase letter or digit.
   Account Type	Select Privileged Account. For permission details, see Account permissions in an ApsaraDB RDS for SQL Server instance.
   New Password	8–32 characters, containing at least three of: uppercase letters, lowercase letters, digits, and special characters (! @ # $ % ^ & * ( ) _ + - =).
   Confirm Password	Re-enter the password.
   Description	(Optional) Enter a description to identify the account.

4. Click OK.

Step 3: Restore the full backup file to the RDS instance

The AliyunServiceRoleForDBS service-linked role is created automatically the first time you use the backup feature of ApsaraDB RDS. For more information, see How do I create a service-linked role for Data Disaster Recovery?

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region of your RDS instance, then click the instance ID.

2. In the left-side navigation pane, click Backup and Restoration, then click Migrate OSS Backup Data to RDS.

   If the button is not visible, check that your RDS instance meets the SQL Server edition and instance family requirements listed in Prerequisites.

3. Click Next twice to reach the Import Data step.

4. Configure the following parameters.

   If this is your first time migrating backup data from OSS to ApsaraDB RDS, you will be prompted to authorize access. Click Authorize, then Confirm Authorization Policy.

   Parameter	Description
   Database Name	Enter the name for the destination database on the RDS instance.
   OSS Bucket	Select the OSS bucket that contains the full backup file.
   OSS File	Select the backup file. Enter a prefix in the search box and click the search icon to find it. The list shows each file's name, size, and update time.
   Cloud Migration Method	Select Immediate Access (Full Backup).
   Consistency Check Mode	Select Synchronous DBCC.

   

5. Click OK and wait for the import to complete. To check progress, click Databases in the left-side navigation pane and verify the status of the destination database.

Step 1: Configure the RDS instance

Step 2: Configure the ECS instance

Open the ports that MSDTC requires on the ECS instance's security group. You need two inbound rules: one for the Remote Procedure Call (RPC) endpoint mapper (port 135) and one for the dynamic RPC port range (1024–65535).

1. Log on to the ECS console.

2. Choose Instances & Images > Instances.

3. In the top navigation bar, select the region of the ECS instance.

4. Click the ECS instance ID.

5. Click Security Groups in the top navigation bar.

6. Find the security group and click Manage Rules in the Actions column.

7. On the Inbound tab, click Add Rule and configure the following parameters for the first rule.

   Parameter	Value
   Action	Allow
   Priority	1
   Protocol Type	Custom TCP
   Port Range	135
   Source	The two IP addresses shown under Data Security > Distributed Transaction Whitelist in the RDS console. You can also call the DescribeDBInstanceIpHostname API operation to retrieve them.
   Description	Enter a description (2–256 characters, cannot start with http:// or https://).

   

8. Click Save.

9. Add a second inbound rule with the same parameters, but set Port Range to 1024/65535.

Step 3: Configure the Windows operating system

Configure the ECS instance's Windows operating system to allow MSDTC to resolve the RDS instance by hostname and to participate in distributed transactions.

1. Log on to the ECS instance (this guide uses Windows Server 2016).

2. Open the hosts file at C:\Windows\System32\drivers\etc\hosts.

3. At the end of the file, add the internal IP address and hostname of the ECS instance on which the RDS instance runs. Find this information on the Distributed Transaction Whitelist tab under Data Security in the ApsaraDB RDS console.

   You can also call the DescribeDBInstanceIpHostname API operation to retrieve the internal IP address and hostname.

   

   

4. Save the hosts file.

5. Open Control Panel, choose System and Security > Administrative Tools, then double-click Component Services.

6. Navigate to Component Services > Computer > My Computer > Distributed Transaction Coordinator.

7. Right-click Local DTC and select Properties.

8. Click the Security tab and configure the DTC security settings.

   

9. Click OK. When the MSDTC Service dialog appears, click Yes and wait for the MSDTC service to restart.