检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Map the newly created login account to the database user permissions that have been migrated to the RDS for SQL Server DB instance to ensure permission consistency. declare @DBName nvarchar(200) declare @Login_name nvarchar(200) declare @SQL nvarchar(MAX) set @Login_name = 'TestLogin7
(Optional) Configuring your own DNS server Figure 5 DNS Server Table 8 DNS server information Parameter Description DNS Server Enable this option if you need to use the IP address of your own DNS server as the source or destination database IP address.
If the destination is master/standby Redis 4.0 and the requirepass parameter (a password) is not set on the master or slave node, the master/standby switchover of the destination database is supported.
If the destination is master/standby Redis 4.0 and the requirepass parameter (a password) is not set on the master or slave node, the master/standby switchover of the destination database is supported.
Table 1 DB engines and policies DB Engine Authorization Policy MySQL RDS ReadOnlyAccess Microsoft SQL Server RDS ReadOnlyAccess PostgreSQL RDS ReadOnlyAccess MongoDB DDS ReadOnlyAccess DDS DDS ReadOnlyAccess GaussDB(DWS) DWS ReadOnlyAccess TaurusDB GaussDBReadOnlyAccess DDM DDMReadOnlyAccess
(Optional) Configuring your own DNS server Figure 5 DNS Server Table 8 DNS server information Parameter Description DNS Server Enable this option if you need to use the IP address of your own DNS server as the source or destination database IP address.
The service database does not support point-in-time recovery (PITR). Binlogs cannot be forcibly deleted. Otherwise, the DR task fails. The service database does not support the reset master or reset master to command, which may cause DRS task failures or data inconsistency.
The column names in the source database tables cannot end with a backslash (\). The source database does not support the reset master or reset master to command, which may cause DRS task failures or data inconsistency.
The service database does not support point-in-time recovery (PITR). Binlogs cannot be forcibly deleted. Otherwise, the DR task fails. The service database does not support the reset master or reset master to command, which may cause DRS task failures or data inconsistency.
For example: CREATE TABLE `test11` ( `id` int NOT NULL, `c1` int DEFAULT NULL /*!80023 INVISIBLE */, PRIMARY KEY (`id`)); Source database The source database must be the primary node of the TaurusDB instance.
model tempdb rdsadmin resource The new database name contains 1 to 64 characters, including letters, digits, underscores (_), hyphens (-), and periods (.).
Edition 2016 SP2 or later, 2017, 2019 and 2022) RDS for SQL Server (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022 and Standard Edition 2016 SP2 or later, 2017, 2019 and 2022) TaurusDB (standard and basic editions) This function is in restricted use.
New database name The new database name must be unique and cannot be any of the following (case-insensitive): msdb master model tempdb rdsadmin resource The new database name contains 1 to 64 characters, including letters, digits, underscores (_), hyphens (-), and periods (.).
2019 and 2022) ECS-hosted Microsoft SQL Server (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022 and Standard Edition 2016 SP2 or later, 2017, 2019 and 2022) Microsoft SQL Server-compatible databases on other clouds (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022
entry (hostssl [Username] [Subnet of the RDS instance]);.
) ECS-hosted Microsoft SQL Server (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022 and Standard Edition 2016 SP2 or later, 2017, 2019 and 2022) Microsoft SQL Server-compatible databases on other clouds (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022 and Standard
(The update takes effect when the DNS server IP address changes.) recover: Restore the default DNS server IP address. (Restoration may cause domain name resolution failures. Exercise caution when performing this operation.)
Edition 2016 SP2 or later, 2017, 2019 and 2022) RDS for SQL Server (Enterprise Edition 2012, 2014, 2016, 2017, 2019 and 2022 and Standard Edition 2016 SP2 or later, 2017, 2019 and 2022) RDS for PostgreSQL (versions 9.5, 9.6, 10, 11, 12, 13, 14, 15, and 16) This function is in restricted
Map the newly created Login account to the database user permissions that have been migrated to the RDS for SQL Server DB instance to ensure permission consistency. declare @DBName nvarchar(200) declare @Login_name nvarchar(200) declare @SQL nvarchar(MAX) set @Login_name = 'TestLogin7
The value can be desc (descending order) or asc (ascending order). The default value is desc. instance_ids No Array of strings List of database instance IDs.
