Comments
Sort by recent activity
Thank you for reply. I have install SQL Compare just on my PC on development network. On other servers on other networks I use SQL Change Automation, before I use SDK. It's not many problems but when appears SQL script is crucial. Problems appears mostly because of the data, which was different as data on my system. And not all servers are sync every time so SQL script are different on different servers (DB's). / comments
Thank you for reply.I have install SQL Compare just on my PC on development network. On other servers on other networks I use SQL Change Automation, before I use SDK. It's not many problems but whe...
I found problem. If SQL procedure is open through Tab History then syntax checker not work. When close opened SQL SP and open again from object explorer, syntax checker work again. I hope in next upgrade syntax checker will work ... / comments
I found problem.If SQL procedure is open through Tab History then syntax checker not work. When close opened SQL SP and open again from object explorer, syntax checker work again.I hope in next upg...
Hello Thank you for respond. I found mentioned solution on forum and try but no success. "netsh http show iplisten" give me 127.0.0.1. This is OK. Then I try update again but today a little different: - First I stop the Redgate service. - Then I rename "...Share Client" folder ("...Share Client BAD"). - Start service. You must start service or SQL Compare 14 not work. - Start SQL Compare 14. - Start update from SQL Compare 14. Just run installer then close SQL Compare 14. Installer must runing! - Stop service (this is different from my previous updates, I never stop service till today. Installer must runing!) - Now in installer window start install and wait to finish - Update was successfully finished [image] I think the stop service was solution in my case, because I newer again stop service. After successfully update SQL Compare 14, I successfully update SQL Prompt 9 and SQL Change Automation too. Thank you again. / comments
HelloThank you for respond.I found mentioned solution on forum and try but no success."netsh http show iplisten" give me 127.0.0.1. This is OK.Then I try update again but today a little different:-...
Hello Thank you very much for your help and time. I didn't see highlighted sentence [image] though I read documentation a few time. Now comparison work very well. [image] Regards / comments
HelloThank you very much for your help and time. I didn't see highlighted sentence though I read documentation a few time. Now comparison work very well. Regards
Hello Thank you for your post. I prepare Filter.scpf file with SQL Compare then modified my script: .... $FilterPath = 'D:\Filters\Filter.scpf ' $syncResult = Sync-DatabaseSchema -Source $Conn1 -Target $Conn2 -FilterPath $FilterPath -IgnoreAdditional -SQLCompareOptions $Options -AbortOnWarningLevel None -QueryBatchTimeout 60 But now get this error: SQLCompare.exe terminated with the exit code 8: Unsatisfied argument dependency.
Either an argument was missing, or two incompatible arguments were used.
Call the command with a valid set of arguments. I try -FilterPath 'D:\Filters\Filter.scpf' and -FilterPath $FilterPath but no difference.
I looking documentation but can't find where I made a mistake. Sync-DatabaseSchema -Source <Object> -Target <DatabaseConnection> [-FilterPath <string>] [-IgnoreStaticData] [-IgnoreAdditional] [-SQLCompareOptions <string>] [-SQLDataCompareOptions <string>] [-TransactionIsolationLevel <TransactionIsolationLevel>] [-QueryBatchTimeout <int>] [-AbortOnWarningLevel <WarningSeverity>] [-IgnoreParserErrors] [-SqlCmdVariables <hashtable>] [<CommonParameters>] Do you have some example with -FilterPath argument? Thanks again.
/ comments
HelloThank you for your post.I prepare Filter.scpf file with SQL Compare then modified my script:....$FilterPath = 'D:\Filters\Filter.scpf '$syncResult = Sync-DatabaseSchema -Source $Conn1 -Target ...
This is happening to me too. SSMS 18.5 and SQL Search 3.5.0.2590. Reconnected server in Object explorer help until SSMS is reopened. / comments
This is happening to me too. SSMS 18.5 and SQL Search 3.5.0.2590.Reconnected server in Object explorer help until SSMS is reopened.
Thanks for your reply, I think this article will help for now. [image]
Uros / comments
Thanks for your reply, I think this article will help for now.
Uros