Comments
Sort by recent activity
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
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 don't know if redgate is still developing SCA. As far as I can tell, they are pushing flyway to replace it. / comments
I don't know if redgate is still developing SCA. As far as I can tell, they are pushing flyway to replace it.
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...
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
Note sure this is my issue. I have my current tools licensed and working. In SQL Toolbelt, I have SQL Compare 14 In SQL Compare 14, it offers me to install SQL Compare 15, but it warns me that I don't have a license for it. My question is: Should SQL COmpare 15 be part of my subscription via SQL Toolbelt? / comments
Note sure this is my issue.I have my current tools licensed and working.In SQL Toolbelt, I have SQL Compare 14In SQL Compare 14, it offers me to install SQL Compare 15, but it warns me that I don't...
Thank you very much maxschafintact! I will try this, the performance was very annoying indeed! Éric / comments
Thank you very much maxschafintact!I will try this, the performance was very annoying indeed!Éric
Hi Dan, We currently have a pretty large project using SCA and we have all our programmable objects neatly organized. I don't want to change any of this. Right now, I have copied [image] the necessary code into the migration script manually. Having duplicated code at this point is not the end of the world for us event tough it might get out of hand if we keep doing so. One suggestion: During the import of changes, new PO could have a checkbox like option where we could choose to put it in the migration script directly instead of the PO folder. Regards, Éric / comments
Hi Dan,We currently have a pretty large project using SCA and we have all our programmable objects neatly organized. I don't want to change any of this.Right now, I have copied the necessary code ...