SQL Change Automation 4

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.


Didn't find what you were looking for?