SQL Change Automation 5

SQL Change Automation and Amazon RDS

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.

This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?