Comments
Sort by recent activity
Just in case someone else encounter the same problem Trust Server Certificate=True changed to TrustServerCertificate=True Multi Subnet Failover=False changed to MultiSubnetFailover=False
Remove the space in key will solve the problem
/ comments
Just in case someone else encounter the same problemTrust Server Certificate=True changed to TrustServerCertificate=TrueMulti Subnet Failover=False changed to MultiSubnetFailover=False
Remove the s...
DanC said:
Hi @chuck and @Rcurtis Sorry to hear you're experiencing this issue! We are investigating this currently (bug report SCA-2736), and it appears that this bug appeared after version 4.2.20168. You should be able to workaround this by using version 4.2.20168 (or an earlier version): 1 - Uninstall your existing SQL Change Automation installation from the Windows Control Panel 2 - Install an earlier version Installer for 4.2.20168: https://download.red-gate.com/checkforupdates/SQLChangeAutomation/SQLChangeAutomation_4.2.20168.20590.exe
Version 4.2.20176 - June 24th, 2020 aslo introduced configuration error. https://forum.red-gate.com/discussion/87158/keyword-not-supported-trust-server-certificate#latest / comments
DanC said:
Hi @chuck and @Rcurtis Sorry to hear you're experiencing this issue!We are investigating this currently (bug report SCA-2736), and it appears that this bug appeared after version 4...
By the way, I am using the latest version 4.2.20176 - June 24th, 2020 / comments
By the way, I am using the latest version 4.2.20176 - June 24th, 2020
also check the log and event log, nothing found related to the exception.
SQL Change Automation-SSMS-202007160742-17512.log %SystemRoot%\System32\Winevt\Logs\Red Gate Software.evtx
/ comments
also check the log and event log, nothing found related to the exception.
SQL Change Automation-SSMS-202007160742-17512.log%SystemRoot%\System32\Winevt\Logs\Red Gate Software.evtx
@David Atkinson Thanks for your quick response. We are using the repeatable migrations for procedures which start with R__ . Currently we are using Flyaway to do the migration, that's why we need the feature I mentioned. It's will be useful to generate multi scripts by "single file per object".
I will take a glance at the SQL Change Automation tool later.
/ comments
@David Atkinson Thanks for your quick response.We are using the repeatable migrations for procedures which start with R__ .Currently we are using Flyaway to do the migration, that's why we need th...
dhtucker said:
Just tried this again using v7.2.4.11418, error remains unresolved. In response to "git status" I see: $ git status
On branch master
Your branch is up to date with 'origin/master'.
Untracked files:
(use "git add <file>..." to include in what will be committed)
develop/
master/
rc/
nothing added to commit but untracked files present (use "git add" to track)
It's mistaking untracked files for pending changes.
You are right, I saved the sql compare project file under the sql source control git repository which is untracked file for git. And move the project file of sql compare to another folder solve this problem. / comments
dhtucker said:
Just tried this again using v7.2.4.11418, error remains unresolved. In response to "git status" I see:$ git status
On branch master
Your branch is up to date with 'origin/mast...
Dan B said:
Hi RacingCow, The 3.3 build was released in error. Could you please attempt to install the previous version 3.2.6 which you can download from ftp://support.red-gate.com/patches/SQLSearch/09Apr2019/.
Tried to install 3.2.6 and now the sql search was shown in menu now. and the sha-256 of the ssms.exe is b5dec677563868067912322a97acc968de0bc07ceb3ca68f6320f9ba1d2b9840
[image]
/ comments
Dan B said:
Hi RacingCow,The 3.3 build was released in error. Could you please attempt to install the previous version 3.2.6 which you can download from ftp://support.red-gate.com/patches/SQL...
Hi @Jessica, I have upgrade the sql compare to 13.7.8, and test it with previous test case. The generated scripts works now, the index was re-created. Thanks.
/ comments
Hi @Jessica, I have upgrade the sql compare to 13.7.8, and test it with previous test case. The generated scripts works now, the index was re-created. Thanks.
By the way, the version of sql compare is 13.7 .4 and the version of sql source control is 7.0.11
/ comments
By the way, the version of sql compare is 13.7 .4 and the version of sql source control is 7.0.11
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. The weird thing is, my colleague add about 10 stored procedures. But only one of them was shown as dropped on get latest tab, the others are shown as new added on commit tab. / comments
Hi @David Atkinson , We are using the shared model. The stored procedure was added by my colleague, it should shown as new added on commit tab,instead of shown as dropped on get latest tab. ...