Moving from SQL Source Control to Flyway Desktop
Published 02 April 2022
Flyway is the next version of SQL Source Control. SQL Source Control and Flyway can be installed side-by-side during this transition period for testing and planning purposes. They should not be used on the same project.
SQL Source Control 7 is still available for sale and is being actively maintained and supported.
For new customers or customers starting new projects, we encourage you to start with Flyway.
For existing customers, learn more about why we're moving to Flyway and its benefits. If you have any questions, get in touch with our Database DevOps Team.
Please let us know if you have any questions/concerns about this transition. Flyway Desktop should feel familiar to SQL Source Control users since it captures the DDL create script for each object and allows you to version control these changes in Git . You can also import your existing SQL Source Control projects to Flyway and keep all your Git history. We hope to make this transition as easy as possible.
Before making the transition
Learn more about Flyway Desktop by watching this 6.5 minute video for a quick overview.
Flyway Desktop is a standalone tool since it supports over 50 different databases. It integrates directly with Git version control systems. If you are using another version control system (VCS), we still recommend trying Flyway Desktop, but you'll need to use your own VCS cmdline or VCS tool for any version control operations that you need to perform.
Before making the transition to Flyway, there are a few options to try it out:
- Try out Flyway with our Flyway AutoPilot Sample Project.
- Create a new project in Flyway Desktop that goes to a new Git repository/folder. Link your development database or a sample database.
What's next?
- Import your SQL Source Control project to Flyway
- Learn more about:
- How to "Commit Changes" in your development database to version control
- How to "Get Latest" changes from source control and apply these back to your development database - this is needed if you are on a dedicated development database or switching branches
- Deploying - How to deploy changes manually or automatically
Any Questions?
If you have any questions about transitioning from SQL Source Control to Flyway, please get in touch with our Database DevOps Team.
