SQL Change Automation and Amazon RDS
Published 04 M 2020
You can use the SQL Change Automation development and deployment tools with Amazon RDS the same way you use it with on-premise SQL Server.
There is one adjustment that is necessary to get baselining working from RDS to a local development database - the baseline script contains this in addition to the expected script:
DECLARE @associate bit SELECT @associate = CASE SERVERPROPERTY('EngineEdition') WHEN 5 THEN 1 ELSE 0 END IF @associate = 0 EXEC sp_executesql N'SELECT @count = COUNT(*) FROM master.dbo.syslogins WHERE loginname = N''sca''', N'@count bit OUT', @associate OUT IF @associate = 1 BEGIN PRINT N'Creating user [sca] and mapping to the login [sca]' CREATE USER [sca] FOR LOGIN [sca] END ELSE BEGIN PRINT N'Creating user [sca] without login' CREATE USER [sca] WITHOUT LOGIN END GO PRINT N'Altering members of role db_owner' GO ALTER ROLE [db_owner] ADD MEMBER [sca] GO
To get the project working with this baseline script you need to manually modify it to remove the extra statements.