Source control for RDS MS SQL Server

0

Hello, I'm looking for a recommendation for a Source control solution for a team of 5-10 developers that works well with RDS MS SQL Server. Thanks.

asked 2 years ago380 views
2 Answers
1

Not sure what do you mean by Source Control for RDS. For example if you are using Visual Studio you can create a DB project and commit the sql files exactly as if you commit the rest of your CS files. As a source control you can use AWS CodeCommit service. It is compatible with Git

AWS
answered 2 years ago
0

Hello , If I understand your question correctly, you are looking to collaborate as a team and push changes to MSSQL infrastructure as a CICD basis. If that is correct AWS CodeCommit would be your best bet. Take a look into below URL for more details. https://aws.amazon.com/getting-started/hands-on/set-up-ci-cd-pipeline/

If otherwise, working with Visual studio Code + GIT based source control would be your options.

AWS
answered 2 years ago
  • Thank you. I have read about limitations of using Visual Studio as a SQL source control method. Ideally I would like to use something similar to Redgate's SQL Source Control product, but it requires more permissions than are available w/ RDS. Is there a way to integrate SSMS with CodeCommit? I didn't see an obvious method in the article.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions