Flyway

The easiest way to experience the Flyway Service is using Flyway CLI. 1. Enable the serviceConfigure your Flyway project by adding a databasetype, id and name at the top of your project's flyway.toml file.databaseType = "PostgreSql"id = "InsertGUIDhere"name = "ProjectNameHere"You can generate a guid here: Online GUID Generator (encrypt-online.com)The conf/flyway.toml can be found in your Flyway project folder.Save the file.Note: The service does not currently work with flyway.conf files this is something we are working on resolving, please contact [email protected] if this is something you require. To use the service now learn how to convert a conf file to a TOML file here 2. Authenticate with Flyway CLITo use the Flyway Service you will need to authenticate Flyway CLI so that it can communicate with the Redgate Hosted Service.To do this run the following command on Flyway CLI flyway auth -IAgreeToTheEula 3. Publishing insights to the Flyway ServiceTo see your deployment event being published to the service all you need to to is to deploy a migration script to a target of your choice using the following CLI parameters.Ensure that you have at least one pending migration script Run the following commands on your target environment flyway migrate -url=InsertEnvironmentUrlHere -user=InsertUserNameHere -password=*** -publishResult=true -checkDriftOnMigrate=true -environment=InsertEnvironmentNameHere 4. Viewing your deployments in the Flyway ServiceThe flyway migrate operation has now published its results to the Flyway Service. Simply visit to open the pipeline dashboard view. You can drill down to to view any environments that have deployments registered against them for a specific Flyway project. Use show more to view the detailed deployment history for an environment.

Flyway commands can be executed either via > flyway [options] [command] or > flyway [command] [options]. However, note that namespace short-circuiting is only available when the command is specified before the options.For parameters which can be set on each command, see individual commands.All settings in the Flyway namespace can also be set as commandline parameters.Universal parametersThe following flags provide helpful information without carrying out any other operations: Flag Purpose --help-h-? Print the list of available commands and options --version-v Print the Flyway version The following options modify the console output: Flag Purpose -X Extended debug output enabled -q Quiet mode, suppress all output, except for errors and warnings -color Colorize the terminal output -outputType Human or machine-readable output The following command line options modify behavior for all commands: Parameter Tier Type Description configFileEncoding Community String The file encoding to use when loading Flyway configuration files. configFiles Community String The Flyway configuration files to load. workingDirectory Community String The working directory to consider when dealing with relative paths. The following settings can be overridden for all commands: Setting Tier Type Description loggers Community String array Loggers to use. email Community String Email to be used in conjunction with a personal access token. token Community String Personal access token used for licensing Flyway. The following deprecated settings can be overridden for all commands: Setting Tier Type Description licenseKey Teams String Your Flyway license key. Configuration from Standard InputYou can provide configuration options to the standard input of the Flyway command line, using

Issue where objects belonging to the schema history table would appear in the differences table.2.6.5603 - February 21 2020FixesFixed an issue which could reset recently opened projects list.Updated Flyway to v6.2.4Fixes an issue where Flyway could crash if the schema history table was in an unexpected state.Oracle SQL*Plus parsing extended to support SPOOL2.5.5397 - February 18 2020ImprovementsAdded ability to enable verbose logging via help dropdown.General error handling improvements / fixes.FixesEnsure all Redgate CLIs are appropriately signed.Fixed an issue where loading project failed due to a missing config.updated Flyway to v6.2.3Includes fix for dependency redgate.oracle.schemacompare.engine to v5.7.0.26682.4.4938 - February 05 2020ChangesUpdated dependency redgate.oracle.schemacompare.engine to v5.7.0.2630.FixesGeneral error handling improvements / fixes.Avoid cases where RCC crashed with a white screen.Provides additional information in some cases when Flyway failed.2.3.4166 - January 14 2020ImprovementsThe difference table's UI performance has been improved.A better error is displayed when an invalid path is given to the New Project Wizard.ChangesThe auto-generated afterMigrate.sql file has now been renamed to afterMigration__fix_invalid_objects.sql.FixesFixed an issue where the Apply to database tab's content was not updated after a baseline completes.Completing a baseline successfully now displays the correct success message.Fixed an issue where the list of added dependencies, in the script generation tab, was being reported incorrectly.Fixed an issue where we were not accepting underscores in the hostname part of a JDBC URL.2.2.3902 - December 19 2019ImprovementsImproved error handling when oracle jdbc drivers are missing from the flyway installation.Improved error message when schemas are missing from the dev or shadow databases.Changes- The default baseline version is now "001" instead of "0.1".Improved the layout of the baseline page.The "last updated" / "new changes" messages on the "Generate migrations" tab have been improved to be clearer and more visible.FixesFixed an issue which prevented the baseline suggestion message from appearing on the "Apply to database" tab.Automatically generated versions will now preserve leading zeros from the previous version.Fixed an issue where a v2 Deployment Suite for Oracle license key would not correctly activate a v2.1 installation.2.1.3732 - December 13 2019ImprovementsChecking for updates to the tool can now be triggered manually from the Help menu.Log files for the tool can now be reached through the Help menu.Credentials entered in the New project wizard are now encrypted instead of written to the flyway.conf file.The Test connection buttons in the New project wizard now check all the necessary fields are completed.Improve the content and location of baseline messagesChangesThe parameters Username, Password and Schemas are now required in the New project wizard.The Show files on disk buttons have been removed and replaced with clickable folder paths in the header bar.FixesFixed an issue in hybrid mode where the path to the scripts source was being incorrectly resolved.Fixed an issue where the table of migrations

Products All products Redgate Flyway Redgate Monitor Redgate Test Data Manager SQL Toolbelt Essentials SQL SQL Backup SQL Clone SQL Compare SQL Data Catalog SQL Data Compare SQL Data Generator SQL Dependency Tracker SQL Doc SQL Index Manager Redgate Monitor SQL Multi Script SQL Prompt SQL Provision SQL Scripts Manager SQL Search SQL Source Control SQL Test .NET .NET Developer Bundle .NET Reflector ANTS Performance Profiler ANTS Memory Profiler SmartAssembly All products .NET Developer Bundle .NET Reflector ANTS Memory Profiler ANTS Performance Profiler Data Compare for Oracle Data Masker Redgate Flyway Redgate Test Data Manager Schema Compare for Oracle SmartAssembly Source Control for Oracle SQL Backup SQL Clone SQL Compare SQL Data Catalog SQL Data Compare SQL Data Generator SQL Dependency Tracker SQL Doc SQL Index Manager Redgate Monitor SQL Multi Script SQL Prompt SQL Provision SQL Scripts Manager SQL Search SQL Source Control SQL Test SQL Toolbelt Essentials Solutions Overview By Need Standardize Protect Automate Monitor By Role Development Operations IT Management Enterprise leadership By Industry Tech U.S. Federal Australian Government Healthcare Managed Service Providers (MSP) Case studies Insights Our Company Overview Careers Contact us Redgate blog Newsroom Leadership Support Learning & community Learning & community | Redgate Hub Product articles University Events Forums Community Simple Talk Buy now See all products Request a quote Contact sales My account Shopping cart Products All products Redgate Flyway Redgate Monitor Redgate Test Data Manager SQL Toolbelt Essentials SQL SQL Backup SQL Clone SQL Compare SQL Data Catalog SQL Data Compare SQL Data Generator SQL Dependency Tracker SQL Doc SQL Index Manager Redgate Monitor SQL Multi Script SQL Prompt SQL Provision SQL Scripts Manager SQL Search SQL Source Control SQL Test .NET .NET Developer Bundle .NET Reflector ANTS Performance Profiler ANTS Memory Profiler SmartAssembly All products .NET Developer Bundle .NET Reflector ANTS Memory Profiler ANTS Performance Profiler Data Compare for Oracle Data Masker Redgate Flyway Redgate Test Data Manager Schema Compare for Oracle SmartAssembly Source Control for Oracle SQL Backup SQL Clone SQL Compare SQL Data Catalog SQL Data Compare SQL Data Generator SQL Dependency Tracker SQL Doc SQL Index Manager Redgate

Leaders in Environmental ExcavationWith a proven track record of 30+ years, Flyway Excavating stands out as an environmental excavation company dedicated to sustainable solutions for a better future. We specialize in precision excavation techniques that prioritize the preservation of natural habitats and ecosystems. From dam removal to wetland restoration, we employ state-of-the-art equipment and adhere to strict regulatory standards, ensuring the highest level of safety and compliance. Partner with Flyway Excavating for conscientious, forward-thinking solutions in environmental land management. Waterway ServicesRestoring waterways to their natural state is our specialty. We are a waterway contractor who works with conservation districts, watershed groups, government agencies, engineering firms, and private property owners to improve and restore waterways to the way nature meant them to be. Our services include stream restoration, wetland restoration, water quality basins, dam removal, dam rehabilitation, and bridges and culverts. Site ConstructionWe are also excavating contractors, providing environmental excavation and construction services. We take care to work with our environment, not against it, and aim to leave work sites in a better state than they started in. Our excavating services include site preparation, building excavation, parking lots and garages, parks and athletic fields, road construction, and plazas and streetscapes. Set Your Project in Motion TodayAt Flyway Excavating, we’re more than just a company. We’re a team of dedicated individuals with an unwavering passion for our work. Beyond environmental excavation services, we harbor a profound care for the environment. Each one of us is driven by a shared commitment to safeguarding and improving the communities we live and work in.To us, our projects aren’t merely tasks — they’re a priority to restore and preserve natural habitats. Through meticulous excavation techniques, we’re creating a better future for all of us. Our company mission statement, “Improving Environments, Improving Lives,” sums up our ideology that each project we undertake must be to the ultimate benefit of both nature and our client.If you’re ready to take the next steps on your environmental excavation project, contact the team at Flyway Excavating. Our years of experience coupled with our arsenal of cutting-edge equipment makes us the ideal choice for anyone seeking environmental excavation services. OUR WORK CASE STUDY: FOX RUN RESTORATIONA comprehensive floodplain restoration project of two tributaries to Fox Run in Dover Township, PA, the first phase of a plan to transform a former golf course into a township park. CASE STUDY: CULLITON PARKThe revitalization of a community gathering place in southwest Lancaster City, including a playground, pool, splash pad, softball field, and basketball courts.

2.30.9261 - June 25 2020ImprovementsImproved error messaging when attempting to commit if no files are selected.Improved error messaging for when saving migrations scripts fails.ChangesExtended integrated Flyway licenseFixesFixed error when committing if the repository root was not the same as the RCC project root.Fixed the rendering of the changes table on the Version Control tab.2.29.9197 - June 22 2020ImprovementsAdded a confirmation modal when pushing commits.Stop listing remote git branches that have been deleted in the branch-switch dropdown.Enable primary actions to be triggered by pressing ctrl+enter.Allow specific files to be selected for committing.ChangesUpgraded the Redgate Oracle Schema Comparison engine to v5.7.4.3169Upgraded Flyway to v6.4.4FixesFixed an issue where the user-defined logging level was being reset to Default when opening the app.Fixed an issue where no comparison differences would be shown after deleting local migration scripts from the project.Fixed an issue where an error message was being incorrectly displayed during the New Project wizard.Fixed an issue where the default placeholder text for the JDBC Url was missing from the baseline setup modal.2.28.9017 - June 11 2020New FeaturesAdded a couple of new version control integration features:Create new branchesSwitch branches from any tabImprovementsAdded description to the pull and push actionsImproved success message when pulling changesImproved the commit pane designImproved error messages when using the Version Control tabChangesUpgraded the Redgate Oracle Comparison engine to v5.7.4.31292.27.8815 - June 5 2020New Features**Experimental**: Version control Redgate Change Control projects from within the application. This is currently limited to a few basic git actions (pull, push, commit). Learn more.Pull latest changes from the remote repositoryCommit new migration scriptsPush new commits to the remote repositoryImprovementsImproves the information modal shown when editing migration scripts when working with a shadow scripts folder.Adds page auto-refresh after performing a reset or resync of a shadow scripts folder.Improved error messaging throughout the app.ChangesUpgraded Redgate Oracle comparison engine to v5.7.4.3111Upgraded flyway to v6.4.3FixesCorrects the wording of the baseline success messageFixes an issue where the shadow scripts folder desync success message was not cleared on manually refreshing the page.Fixes an issue where updating the shadow scripts folder during a baseline would fail if there were no comparison differences.Fixes an issue with broken styling in the New Project wizard.2.26.8552 - May 28 2020New Features**Experimental**: Use a shadow scripts folder for generating migration scripts instead of a shadow database. Learn moreRequires the environment variable SHADOW_SCRIPTS_FOLDER to be set.Enable users to reset and resync the shadow scripts folder from the help menu.ChangesImproves progress and error messaging in the UI when creating new projects.Improves the copy to clipboard button designImproves styling of error messages arising from flyway failuresFixesRemoves the introductory page from the New Project wizard.Upgrade Redgate Oracle schema comparison engine to v5.7.4.30682.25.8163 - May 14 2020ChangesImproved the types of error messages displayed