Redgate Flyway

This view is currently available in the top white settings cog under Preview features.

See the "Flyway Desktop - Original" tab above if you are still on the previous version.

This page shows the comparison of your schema model on disk and your development database. If there are changes in the development database, then applying what's in the Schema model on disk back to your development database will overwrite these changes and they are gone. If possible, save your development database changes to the schema model before pulling from version control. This will ensure that this page only reflects changes from version control that need to be applied back to your database. Be extra careful that you don't undo your team members changes if you're all working against the same development database.

If you pull down schema model changes from version control which have not been applied to your development database yet, you can apply them on the Update development page. You can click on an object to review the exact differences. Select the objects that you want to update in your development database and click Apply...

You'll have a chance to review the script that will be applied to your development database. We'll let you know if any dependencies are pulled in. Click Apply now to update your development database.

You will get one last prompt to make sure you really want to apply those changes to your development database. If you have unsaved work on your development database, then your changes could be overwritten. This is especially true if you are working on a shared development database and other team members have made changes to the development database. Click Continue and apply to update your development database.

If you pull down schema model changes from version control which have not been applied to your development database yet, you can apply them on the Schema model tab. Click on the Apply to database option in the top left, review and select the relevant changes, and click the Apply to database button.

Clicking Apply to database will prompt you to make sure you really want to apply those changes to your development database. If you have unsaved work on your development db, then your changes could be overwritten. Click Continue to make apply the changes to the database.

You can run the prepare and deploy commands to update the development database

flyway prepare -source=schemaModel -target=development
flyway deploy -environment=development

Next steps

If you have just pulled and are using migrations, validate that your migrations are deployable

Redgate Flyway

Tutorial - Apply database changes from the schema model to your database

Next steps