Sample DevOps scenario with RDS Deploy
The job is to backup 3 databases from RDS to a standard MS SQL Server. Merge data from two of them into the third. Send the third database back to RDS as the new production system. The job will also flush any open sessions to the website, take it offline and put it back online when everything is finished. This is all done in a PowerShell script which is executed from Jenkins so that it can be performed by employees with minimal security access (only have access to that job) and all history is recorded.
Power Shell Script:
In Jenkins click “Build Now” to execute:
RDS Deploy's API returns the status of the replication, initiated over the API, in XML format:
DB replications can be seen in RDS Deploy's UI:
RDS Deploy's API
API Documentation can be found at rdsdeploy-api-help.cloudbasic.net