AWS dms documentation change
Summary
Added SQL script to identify tables without primary/unique keys and fixed comment syntax in stored procedures
Security assessment
The script helps identify potential data integrity issues but does not address security vulnerabilities. Comment syntax changes (-- instead of —) are code formatting improvements. No evidence of security vulnerability remediation or security feature documentation.
Diff
diff --git a/dms/latest/userguide/CHAP_Source.SQLServer.CDC.md b/dms/latest/userguide/CHAP_Source.SQLServer.CDC.md index 6e2451df6..30d876a3b 100644 --- a//dms/latest/userguide/CHAP_Source.SQLServer.CDC.md +++ b//dms/latest/userguide/CHAP_Source.SQLServer.CDC.md @@ -44,0 +45,12 @@ When setting up a SQL Server database for ongoing replication (CDC), you can do +###### Note + +You can use the following script to find all table without a primary or a unique key: + + + USE [DBname] + SELECT SCHEMA_NAME(schema_id) AS schema_name, name AS table_name + FROM sys.tables + WHERE OBJECTPROPERTY(object_id, 'TableHasPrimaryKey') = 0 + AND OBJECTPROPERTY(object_id, 'TableHasUniqueCnst') = 0 + ORDER BY schema_name, table_name; + @@ -171 +183 @@ After running the steps in this section, the non-sysadmin DMS user will have per - @plist varchar(8000), —A delimited list of partitions + @plist varchar(8000), --A delimited list of partitions @@ -173 +185 @@ After running the steps in this section, the non-sysadmin DMS user will have per - @dlm nvarchar(1) —Delimiting character + @dlm nvarchar(1) --Delimiting character @@ -177 +189 @@ After running the steps in this section, the non-sysadmin DMS user will have per - returns @partitionsTable table —Table holding the BIGINT values of the string fragments + returns @partitionsTable table --Table holding the BIGINT values of the string fragments @@ -249 +261 @@ After running the steps in this section, the non-sysadmin DMS user will have per - @partition_list varchar(8000), — A comma delimited list: P1,P2,... Pn + @partition_list varchar(8000), -- A comma delimited list: P1,P2,... Pn @@ -261 +273 @@ After running the steps in this section, the non-sysadmin DMS user will have per - declare @start_lsn_cmp varchar(32); — Stands against the GT comparator + declare @start_lsn_cmp varchar(32); -- Stands against the GT comparator @@ -263 +275 @@ After running the steps in this section, the non-sysadmin DMS user will have per - SET NOCOUNT ON — – Disable "rows affected display" + SET NOCOUNT ON -- – Disable "rows affected display" @@ -401 +413 @@ After running the steps in this section, the non-sysadmin DMS user will have per - [RowLog Contents 1] — After Image + [RowLog Contents 1] -- After Image @@ -455 +467 @@ After running the steps in this section, the non-sysadmin DMS user will have per - SET NOCOUNT OFF — Re-enable "rows affected display" + SET NOCOUNT OFF -- Re-enable "rows affected display" @@ -595 +607 @@ You should create the dmsnosysadmin user account with the same SID on each repli - grant view server state to [DMS_user]—(should be granted to the login). + grant view server state to [DMS_user]--(should be granted to the login).