Using Redgate's Data Compare technology to version control and generate migration scriptsÂ
Published 09 January 2023
You can use our Data Compare technology as part of Flyway Enterprise to capture changes and generate a deployment script for data changes in static/lookup tables. This can be useful if your data sets are large and do not change frequently and you don't want to check for data changes every time you refresh in Flyway Desktop.
You can use the comparison tools to synch to a scripts folder and version control how the data changes over time. You can also compare your development database to a scripts folder containing the latest version from version control or to a downstream database like Production to generate a deployment script that captures any changes to your static data. Once you generate the deployment script, simply save it into your project folder using the naming convention (V<number>__<description>.sql)
. The versioned migration script can then be committed and pushed to version control and flow through your automated deployment process to your downstream environments (e.g., Test, QA, Stage, Production).
Learn more about how to use Data Compare for Oracle or SQL Data Compare, which are part of Flyway Enterprise. Both of these tools have a GUI, command line, and Docker containers.