Posts
Sort by recent activity
Creating Baseline Migration Script
Hi,I have an existing database that I'm trying to use with Flyway.I currently using a trial for the Enterprise edition.I was able to create the schema model, but when I try to create a baseline mig...
Upgrading to Visual Studio 2022 17.9.0
Hello,I'm currently running 17.8.5 and 17.9.0 is now available.Is SCA working fine in this version?Historically there has been issues with VS upgrades, I want to be sure the upgrade is safe.Regards...
Using sqlcmd (:R) inside migration script
Hi,I'm trying to use a new stored procedure inside a migration script.From what I understand, the sp is only created after all the migration scripts have been processed, thus it's not available in ...
Visual Studio Not Responding
sHi,I'm using SCA (4.6.23075.1039) with Visual Studio 2022 (17.5.2, but I also experienced the issue with 17.5.0)When I click on the connect button in the toolbar of a .sql file or via the SQL menu...
SQL Compare 15 and SQL Toolbelt
Hi,I have SQL Toolbelt and when I try to upgrade to SQL Compare 15, it tells me I will have only a trial version.Shouldn't the Toolbelt include the latest version of all it's products?Thanks,Éric
Using a new stored proc in a migration script
Hi,My understanding, is that migration scripts run before the Programmable Objects, so my new stored procedure is not available to my migration script.I can create the sp in the migration script (o...
Is Redgate Change Control going to replace SQL Change Automation
Hi,First, is SQL Change Automation still in development?Will it be replaced by Redgate Change Control?If so, what will be the migration/upgrade path?Regards,Eric Lamontagne
Will SCA support Visual Studio 2022
Hi,I think the question says it all... if the answer is yes, is there any time frame?Regards,Eric Lamontagne
SCA vs Flyway vs Redgate Deploy
Hi,I'm a bit confused about all these options. I've been using SCA for the last 8 months and lately I'm seeing many articles about flyway for database migration. I also see that there is Redgate de...
Creating a new baseline
Hi,I'm not certain how to name it, but what I want to do is create a new "version" of my database schema.We started at version 7.0 by creating a baseline.We then created a migration that we call 7....