A customer recently asked if Redgate's comparison engine is able to generate code to split partitions when a partitioned table is modified. Yes, it can! In this video we demonstrate this in SQL Compare, but the same functionality is also available for automated deployments from SQL Source Control and SQL Change Automation, which use the SQL Compare Engine.

There's a quick and easy way to filter the list of database changes to import in SQL Change Automation in Visual Studio -- just start typing the text of what you'd like to filter by! Redgate's Kendra Little shows how it works in this short video.

At times you may wish to initialize a new Git repo on your client machine. Redgate's Kendra Little shares some tips for doing this in VSCode.

'Dry Run' scripts are incredibly useful in the review and deployment processes for your database changes when you are using Flyway. Flyway deploys to 20+ database platforms