Operations | Monitoring | ITSM | DevOps | Cloud

Flyway provides a lot of flexibility for releasing database changes in a safe and repeatable manner. Earlier this year, we added the ability to automate state-based deployments. This means the structure of the database is defined in version control and Flyway handles updating a target database to match it. The Flyway comparison engine does all the hard work of identifying what’s different and creating a script that will run on the target database to alter it so it matches the latest state.

One kind of data in most relational databases is what we call static data. This is also referred to as lookup data, code data, domain data or even list data. Whatever you like to call it, it’s usually smaller data sets consisting of data that never changes, or changes very slowly. One example might be Canadian postal codes. Another example, and one I’m going to use, is the amateur radio band definitions within a given country.

For nearly 20 years, SQL Prompt has been a trusted companion for database professionals, helping them write cleaner code, reduce errors, and save time. From its earliest days, the focus has been on productivity while removing the repetitive, mundane tasks that slow people down. It’s been about building the reliability and performance that developers and DBAs depend on every day and that story doesn’t stop here.

Avoid the pitfalls of cloud database migration with Redgate Flyway. Learn how automation, schema discipline, rollback strategies, and traceability reduce risk and enable fast, compliant cloud deployments, with these insights from John Q. Martin, Technology Partner Manager at Redgate Software. Cloud migrations promise faster releases and more flexible scaling, but a poorly executed database migration will stop you from exploiting them.

John Q Martin, Technology & Alliances Partner Manager at Redgate, covers 10 mistakes he's made when migrating databases to the cloud - and the strategies he now implements to avoid them happening again. But first, John explains exactly why databases are the hardest part of cloud migration.

Redgate Test Data Manager’s September release introduces AI dataset generation, streamlined database connectivity, and improved validation. These updates eliminate manual work and configuration errors while maintaining security and data quality standards.

Redgate Monitor now supports Oracle Data Guard environments, giving DBAs instant visibility into replication health, lag and role transitions, so Standbys stay in sync and are ready to protect availability and data when needed. DBAs running Oracle Data Guard know that keeping replicas healthy requires constant vigilance. It often involves querying dynamic performance views, such as V$DATAGUARD_STATS, or running Data Guard Broker commands to check lag and role status.

Redgate Monitor now gives you full visibility into activity across Oracle Multitenant environments. With metrics and alerts at both the Container Database (CDB) and Pluggable Database (PDB) level, you can quickly pinpoint performance issues and ensure compliance. With the introduction of Oracle multitenant architecture in Oracle 12c, many teams began consolidating databases into a single Container database (CDB). This helped them to optimize resource usage and simplify patching.

Redgate Flyway is renowned for its low-friction, SQL-first approach. Our customer stories share the wins seen in organizations worldwide for Redgate Flyway. And when it comes to community endorsement for Flyway OSS, the GitHub and Docker statistics prove it, with 9k+ GitHub stars and 50M Docker downloads advocating for its appreciation.

I’m pleased to announce that Flyway continues to improve its support for Oracle databases with every release, focusing on performance, reliability, and developer efficiency. The most recent updates to Flyway Desktop and Flyway CLI specifically target a long-standing challenge for Oracle users: unnecessary table rebuilds when migrating to partitions or when managing partitions.