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.