Data Management Service (DMS) allows you to connect to a user-built database in an on-premises data center by using a public endpoint and then register and manage the database as an instance in the DMS console.
- Exposing the public endpoint of a database may incur network attacks. We recommend that you only use test data on the Internet.
- If you want to use a public endpoint, make sure that you configure a whitelist for the target database to improve data security.
- We recommend that you register your database by using a database gateway, which is more secure and convenient. Currently, the Database Gateway service is in public preview and is free of charge. For more information, see Register a user-built database in an on-premises data center by using a database gateway.
- Currently, DMS allows you to register the following types of databases as instances by using public endpoints:
- SQL Server
DMS is activated.
You are a database administrator (DBA) or a DMS administrator.
Log on to the DMS console.
Move the pointer over the plus sign (+) in the upper-left corner and select Add instance. The Add instance dialog box appears.
You can also open the Add instance dialog box in the following way:
- In the top navigation bar, choose System Management > Instance. On the Instance List tab of the Instance page, click New in the upper-left corner.
In the Add instance dialog box, click the Public Network tab.
In the Public Network section, select a database type.
In the dialog box that appears, set the parameters as required. The following table describes the parameters.
Tab Parameter Description Basic Information Database Source The category of the data source. Set this parameter to Public Network. Database type The type of the database to be registered. Instance Area The Alibaba Cloud region that is geographically close to the region where the target database is deployed. Login Address The public endpoint that is used to connect to the database. Port The port that is used to connect to the database. Database account The username that you use to log on to the database. Database password The password that you use to log on to the database. Control Mode The control mode that is used to manage the instance in DMS. For more information, see Control modes. Advanced Information Environment type The type of environment where the database is deployed. Instance Name The name that you specify for the instance in DMS. Enable DSQL Specifies whether to enable the cross-database query feature for the database. For more information, see Cross-database query. OnlineDDL Specifies whether to allow changing schemas without locking tables for the database and the specific method. For more information, see Change schemas without locking tables. DBA The DBA of the instance who is allowed to grant permissions to users. query timeout(s) The timeout interval of the statement that is used to query data. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security. export timeout(s) The timeout interval of the statement that is used to export statistics. When the specified time interval is reached, the target statement run in the SQL editor is stopped to protect the database security.
On the Basic Information tab, click Test connection in the lower-left corner. Wait until the connectivity test is passed.
If the test fails, check the parameter values that you specify.
Click Submit. Now you have registered a database in your on-premises data center as an instance in DMS and the instance appears in the left-side navigation pane of the DMS console. You can view and manage the instance in the DMS console.