CODEWITHSUNDEEP
sql-serverdatabase-migrationflywayrdsawsdeploy
Anders Lundsgard
Anders Lundsgard

Reputation: 797

Automating SQL schema changes on AWS RDS

What are the most common tooling and best practices to deploy SQL changes on AWS RDS databases?

Now we are considering a temporary flyway docker container running in our ECS, but it would be great if any of the managed AWS services had a solution for it.

Upvotes: 0

Views: 1571

Answers (2)

Axel Fontaine
Axel Fontaine

Reputation: 35169

You want your applications to always have an up-to-date database to ensure that all the objects they need are present. Therefore you should keep together what belongs together and run your migrations on application or container startup. This in turn means packaging Flyway directly into your Docker image.

Upvotes: 0

Ashan
Ashan

Reputation: 19748

Upto now, there aren't any manage services for sql migrations since its mostly unique for the database instance type(mysql, oracle & etc).

Generally if you go for code first approach, migrations are kept in the forms of changes, in a managed schema in code, while for database first approach, sql DML scripts are maintained.

Its also good a practice to automatically run these on continuous delivery tool, if any changes are available.

  • List item

Upvotes: 2

Related Questions