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.