Activity overview
Latest activity by JeromeL
Change automation plugin broken under Visual Studio 17.9
Hi. After upgrading to Visual Studio 17.9, the change automation pluggin is broken. It is impossible to show the dialog to change the DB connection. Clicking the button does nothing and we found th...
Problem after update to Visual Studio 17.8
Hi.We've just updated Visual Studio to the latest version, 17.8. Since then, the plugin crashes on build/cleanup or even opening the SCA tool window.The error ->MSBUILD: Error: : Method not found:...
Just to clarify my post, I understand that the workaround is to copy or edit the .sqlproj.user manually, but is there a pending issue on this? The tool should be able to do this on his own. At least one of my colleagues is experiencing the same thing. / comments
Just to clarify my post, I understand that the workaround is to copy or edit the .sqlproj.user manually, but is there a pending issue on this? The tool should be able to do this on his own. At leas...
Hi @DanC, I updated my tools yesterday and I am experiencing similar problems since. When creating a new branch, the project.sqlproj.user is created nearly empty, it lacks the property group and target database tags. When I open VS, it loads and then crashes VS completetely. The workaround I found is to copy the .sqlproj.user from my trunk branch. The file has then a target database and I can change it. In SSMS, it does not crash but changing the database with the SCA dialog does not work. The testing connection works, but when I click OK it reverts to connection not defined. Before it crashed, in VS, it displayed the default connection, which seems to be (localdb)\projectsv13\db name. I've been able to connect to it in SSMS without any problem. So I don't really get it... VS version : 4.5.23068.948 SSMS plugin version : same Thanks / comments
Hi @DanC, I updated my tools yesterday and I am experiencing similar problems since. When creating a new branch, the project.sqlproj.user is created nearly empty, it lacks the property group and ta...
Thanks Peter,
I will take another look. Last time I tried it did not generate a script with a temporary table. Good to know column order will not be taken care of at deployment, I will pay attention to this. Jerome
/ comments
Thanks Peter,
I will take another look. Last time I tried it did not generate a script with a temporary table. Good to know column order will not be taken care of at deployment, I will pay attentio...
Column order with SQL Change automation
Hi.I was wondering how column order was taken into account under SCA. I just changed my project file options for column order like this :
<SyncOptionIgnoreColumnsOrder>False</SyncOptionIgnoreColum...
JeromeL said:
Thanks for the comprehensive answer. I was discussing with support recently over SOC and SCA and you'll be glad to know that pre/post scripts has just been released (6.2.4.8035). Here is the doc : https://documentation.red-gate.com/soc6/common-tasks/working-with-pre-post-deployment-scripts I'll give it a go myself.
released yesterday august 22nd, be sure to check frequent updates! / comments
JeromeL said:
Thanks for the comprehensive answer. I was discussing with support recently over SOC and SCA and you'll be glad to know that pre/post scripts has just been released (6.2.4.8035)...
Thanks for the comprehensive answer. I was discussing with support recently over SOC and SCA and you'll be glad to know that pre/post scripts has just been released (6.2.4.8035). Here is the doc : https://documentation.red-gate.com/soc6/common-tasks/working-with-pre-post-deployment-scripts I'll give it a go myself. / comments
Thanks for the comprehensive answer. I was discussing with support recently over SOC and SCA and you'll be glad to know that pre/post scripts has just been released (6.2.4.8035).Here is the doc : h...
Using SQL Change Automation project with sql compare
Should I be able to use SQL Compare with a SQL Change Automation project? It looks like SQL Compare opens the schema but when comparing, it shows me only differences, as if the schema was empty.Thanks