SQL Change Automation and Amazon RDS
Published 04 March 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.