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

Step 1: Upload a full backup file of the set of books to an OSS bucket

1. Log on to the OSS console.

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

3. Configure the following parameters and retain the default values for other parameters. Then, click OK.

   Parameter	Description
   Bucket Name	Enter a name for the bucket.
   Region	Select the region in which you want to create the bucket. Important Make sure that the bucket resides in the same region as the ECS instance and RDS instance.
   Storage Class	Select IA.
   Redundancy Type	Select LRS.
   ACL	Select Private.
   Versioning	Select Not Activated.
   Encryption Method	Select None.
   Real-time Log Query	Select Not Activated.

   Note

   For more information, see Create buckets.

4. In the left-side navigation pane, click Buckets. On the page that appears, click the bucket that you created.

5. In the left-side navigation pane of the page that appears, choose Object Management > Objects. On the page that appears, click Upload Object.

6. Drag the full backup file that you want to upload to the Files to Upload field. Alternatively, click Select Files and select the full backup file.

   Note

   For more information, see Upload objects.

   

Step 2: Create a privileged account for the RDS instance

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

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

3. Click Create Account.

4. Configure the following parameters and click OK.

   Parameter	Description
   Database Account	Enter a username for the account. The name can be up to 50 characters in length and can contain lowercase letters, digits, and underscores (_). It must start with a lowercase letter and end with a lowercase letter or a digit.
   Account Type	Specify the type of the account. Select Privileged Account. For more information, see Account permissions in an ApsaraDB RDS for SQL Server instance.
   New Password	Enter a password for the account. The password must meet the following requirements: It must be 8 to 32 characters in length. It must contain at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters. It can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =
   Confirm Password	Enter the password for the account again.
   Description	Enter a description that helps identify the account.

Step 3: Restore the full backup file from the OSS bucket to the RDS instance

1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

2. In the left-side navigation pane of the page that appears, click Backup and Restoration. On the page that appears, click Migrate OSS Backup Data to RDS.

   Note

   If you cannot find the button, check whether the SQL Server version and RDS edition of the RDS instance meet requirements. For more information, see Preparations.

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

4. Configure the following parameters.

   Parameter	Description
   Database Name	Enter the name of the destination database on the RDS instance.
   OSS Bucket	Select the OSS bucket in which the full backup file is stored.
   OSS File	Specify the full backup file that you want to import. You can enter a prefix in the search box and click the search icon to search for the full backup file in fuzzy match mode. The system displays the name, size, and update time of each full backup file that is returned. Select the backup file that you want to migrate to the RDS instance.
   Cloud Migration Method	Select Immediate Access (Full Backup).
   Consistency Check Mode	Select Synchronous DBCC.

   Note

   If you migrate backup data from OSS to ApsaraDB RDS for the first time, the system prompts you to authorize ApsaraDB RDS to access your resources in OSS. In this case, click Authorize and then Confirm Authorization Policy.

   

5. Click OK.

   Note

   Wait until the full backup file is imported into the destination database on the RDS instance. You can click Databases in the left-side navigation pane to view the status of the destination database.

Step 1: Configure the RDS instance

Step 2: Configure the ECS instance

Step 3: Configure your Windows operating system

Configure the Windows operating system to allow distributed transactions. For example, you need to enable ports and configure host mapping settings and DTC security settings.

1. Log on to the ECS instance. In this example, the ECS instance runs Windows Server 2016.

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

3. Enter the required information about the RDS instance at the end of the hosts file. You can view the required information on the Distributed Transaction Whitelist tab of the Data Security page in the ApsaraDB RDS console. The required information includes internal IP address and hostname of the ECS instance on which the RDS instance runs.

   Note

   You can also call the DescribeDBInstanceIpHostname operation to query the internal IP address and hostname of the ECS instance on which the RDS instance runs.

   

   

4. Save the hosts file.

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

6. Choose Component Services > Computer > My Computer > Distributed Transaction Coordinator.

7. Right-click Local DTC and select Properties.

8. Click the Security tab and configure the parameters.

   

9. Click OK. In the MSDTC Service message, click Yes. Then, wait for the MSDTC service to restart.