How to "Get Latest"
Published 06 July 2022
EDITION: TEAMS EDITION: ENTERPRISE
In SQL Source Control, if you are working in a dedicated development environment or you switch branches, then you need to get the latest changes from version control and apply them to your development database.
After moving to Flyway Desktop, you'll still need to pull the latest changes from the repository and apply them to your development database. It's best to visit the Schema Model tab first and make sure there are no changes to your development database that haven't been committed yet. This way, when you pull the latest from the repository, you'll know these are all changes from the repo that need to be applied and conflicts will be picked up if you made a change to an object and you try to pull a change that someone else made to that object.
In Flyway Desktop:
- Visit the Schema Model page to make sure you don't have any pending changes to your development database.
- Open the Version Control sidebar and Pull the latest changes from the remote repository to your local repository. Once you've pulled, the database object changes are now in your project folder on disk.
- On the Update development page, click on the row to view how the object has changed at the bottom. Select which changes you want to apply to your development database. Click Apply...
- Review the script that will be executed on your development database. If needed, you can edit the script. Click Apply now. You will get a confirmation dialog to make sure you are happy to update your development database. (Note: If you are on a shared development database, you might undo co-workers changes because we are just comparing the schema model on disk to the development database and showing you all the differences. That's why it's important to save any pending changes in step 1 above.)
Your development database is now updated with the all the changes you selected from version control, and you can continue your work.
Learn more about applying the changes on disk to your development database.