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.