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.