Activity overview
Latest activity by BogdanS
Hello DanC, Thank you for the reply. I have seen in a previous post that this was once proposed as a feature. Is there any discussion about adding this in the near/distant future? Thank you, Bogdan / comments
Hello DanC,Thank you for the reply. I have seen in a previous post that this was once proposed as a feature. Is there any discussion about adding this in the near/distant future?Thank you,Bogdan
SQL Compare only indexes
Currently there is an option to exclude indexes.I am wondering if there is an option to include only indexes since we can't exclude the Table object type from our scripts.Thank you,Bogdan
Hello, We are also interested in the option of only comparing indexes. I'm curious if this has been implemented or if it is added in the backlog. Regards, Bogdan / comments
Hello,We are also interested in the option of only comparing indexes.I'm curious if this has been implemented or if it is added in the backlog.Regards,Bogdan
For anyone facing this problem. You need to install the powershell module: Install-Module -Name SqlChangeAutomation -AllowClobber -Force -AcceptLicense And from the powershell task navigate to the install path: C:\Program Files\WindowsPowerShell\Modules\SqlChangeAutomation\$version\SDC Then you can call the sqldatacompare application / comments
For anyone facing this problem.You need to install the powershell module:Install-Module -Name SqlChangeAutomation -AllowClobber -Force -AcceptLicenseAnd from the powershell task navigate to the ins...
Hello Pete I have tried the 3rd approach. I tested the script on premises. The problem i got is that the powershell doesn't recognize sqldatacompare.exe in Azure DevOps. Are you sure this is possible without previous installation? Do I have to change folders to make it point to the installation path? / comments
Hello PeteI have tried the 3rd approach. I tested the script on premises. The problem i got is that the powershell doesn't recognize sqldatacompare.exe in Azure DevOps. Are you sure this is possibl...
Data comparison in Azure DevOps using SQL Change Automation
Currently we are working on implementing database releases using Azure DevOps and SQL Change Automation.The problem is that I haven't been able to compare data. What I need to do is Compare two tab...
Hello Eddie, I tried the switch and enabled logging. Unfortunately there is no performance improvement (and no errors in the logs). I guess there is nothing i can do. Thank you for the help ! / comments
Hello Eddie,I tried the switch and enabled logging. Unfortunately there is no performance improvement (and no errors in the logs). I guess there is nothing i can do.Thank you for the help !
Hello Eddie, Thank you for the reply. I will try out your suggestion. Do you have any idea on the decrypt switch? it is not in the list that you linked. / comments
Hello Eddie,Thank you for the reply. I will try out your suggestion.Do you have any idea on the decrypt switch? it is not in the list that you linked.
Hello Eddie, Thank you for the reply. I have seen that suggestion but couldn't seem to find a switch for that option. Could you please advise? To answer your question: I have 2 compares done per project (due to in-memory tables) the two compares take like 5 minutes together and i was wondering if there is any way of reducing that time since my goal is to improve the deployment time. Will lowering the log level help in my case? In this path %localappdata%\Red Gate\Logs i don't have any log for SQL compare so i guess there is no logging. Any ideas? Thank you, Bogdan / comments
Hello Eddie,Thank you for the reply. I have seen that suggestion but couldn't seem to find a switch for that option. Could you please advise?To answer your question: I have 2 compares done per proj...
Improve performance for command line compare
Hello,Currently we have an automated process of deploying sql changes based on TFS checkins we compare source control with our database to obtain the required differences.These are the options that...