Activity overview
Latest activity by EricLamontagne
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...
Hello ode2joy, Your baseline cannot be more recent than the db you want to migrate/upgrade. You'll need to have a baseline based on the version of the db (or even older I guess) and then add migration scripts to upgrade it to the latest version. Eric / comments
Hello ode2joy, Your baseline cannot be more recent than the db you want to migrate/upgrade.You'll need to have a baseline based on the version of the db (or even older I guess) and then add migrati...
Hello Annie, Yes this is the error I'm referring to, but it was fixed. Which version of SCA are you using? I have version: 4.6.24045.3134 Regards, Éric [image] / comments
Hello Annie,Yes this is the error I'm referring to, but it was fixed.Which version of SCA are you using?I have version: 4.6.24045.3134Regards,Éric
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...
Hi @DanC, Thanks for the update. On a first check, it does work yes! Eric / comments
Hi @DanC,Thanks for the update.On a first check, it does work yes!Eric
I found this: Using include scripts in Visual Studio - SQL Change Automation 4 - Product Documentation (red-gate.com) Only pre and post migration support :r including scripts. I tried to do it that way, but again, not much success, the programmable object scripts are not found / comments
I found this: Using include scripts in Visual Studio - SQL Change Automation 4 - Product Documentation (red-gate.com)Only pre and post migration support :r including scripts.I tried to do it that w...
If I just do a deploy in Visual Studio 2022, it actually works [image] It's when I build the project that it fails. The error is: C:\I4\Analytics\Datawarehouse\ProligentDW\ProligentDW.sqlproj: Error: : Error parsing line 2, column 1: Incorrect syntax near GO. Error parsing line 5, column 1: Incorrect syntax near :.: Error parsing line 2, column 1: Incorrect syntax near GO. Error parsing line 5, column 1: Incorrect syntax near :. Done building project "ProligentDW.sqlproj" -- FAILED. / comments
If I just do a deploy in Visual Studio 2022, it actually works It's when I build the project that it fails.The error is:C:\I4\Analytics\Datawarehouse\ProligentDW\ProligentDW.sqlproj: Error: : Err...
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...
Ok, I decided to install it anyway. It seems to be working, showing that I have it licensed. I think the issue is only with the update warning me about the license. Thanks, Eric / comments
Ok, I decided to install it anyway.It seems to be working, showing that I have it licensed.I think the issue is only with the update warning me about the license.Thanks,Eric