Operations | Monitoring | ITSM | DevOps | Cloud

Guided Shadow Configuration removes the setup overhead of shadow databases in Flyway Desktop, allowing teams to adopt migrations-based workflows quickly and safely with minimal configuration. A Shadow Database is a disposable, ‘sandbox’ database that Flyway uses to generate and verify migration scripts.

Once more in this series, we’re moving into areas where I’m not entirely comfortable. I haven’t built a PHP plugin and web page, ever. However, we’re going to put the LLM/AI and associated agents to work on this task. As with so much else when working with AI, it all starts with the prompt, so let’s go there.

SQL Compare and SQL Data Compare v16 introduces SQL Server 2025 support and improved credential security. Plus, SSMS 22 integration is coming soon. We have just released a new major version of SQL Compare and SQL Data Compare – version 16. This major version has two big items and one coming soon.

Because I don’t want to have to fight with our support team (they’re awesome, but busy) I decided that, initially, I’m going to host dbRosetta at ScaryDBA.com. I have full control of the web site, and I won’t be breaking Redgate Software entirely if I accidently do something silly. Before starting the process of developing our next prompt, or set of prompts, I discussed the project with CoPilot. We agreed to break the next part into two pieces.

Since I’m starting development with the dbRosetta database, and since I’m way more comfortable with databases than with code, I’m going to continue within the database sphere for a bit as we build out dbRosetta. My next step is to work with the AI to get a pipeline in place to take our database code and deploy it to Azure Flex Server.

In our latest Redgate Flyway Enterprise release, you can store a snapshot directly in the target database, making drift detection and rollback strategies easier and more reliable whether you’re using state-based or migrations-based deployments.