Changing Flyway script locations from the command line

If you are looking for an open source data base source control and migration tool, I have found Flyway to be an excellent tool that works with both Oracle and Microsoft SQL Server, and many more. How and why is a topic for later, but for now, here’s a quick tip on how to change the flyway migrate call to select different locations from the command line or any scripting language.

Read More

SELECT * FROM dbo.intro...

Hello there, thanks for checking out this blog. I’m aiming to make this blog useful for other developers that are interested in learning how to apply agile practices to their databases, and help skill up on new ways to work with data within the Microsoft and Apache stacks. I’ve worked with various databases for 10+ years across different business areas, so hopefully there’s going to be something on this site that can help you out.

Read More