Improve performance for command line compare
BogdanS
Posts: 12 Bronze 1
in SQL 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 we use:
/Options:f,iu,ib,icc,ich,ic,icm,IgnoreDatabaseAndServerName,ie,ifg,ift,iilp,iit,infr,ip,iqen,irpt,ist,ito,iup,iw,iweo,incd,iip,isi,adus /TransactionIsolationLevel:serializable
Any suggestions on increasing performance? Any switches/options that I can use?
Thank you
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 we use:
/Options:f,iu,ib,icc,ich,ic,icm,IgnoreDatabaseAndServerName,ie,ifg,ift,iilp,iit,infr,ip,iqen,irpt,ist,ito,iup,iw,iweo,incd,iip,isi,adus /TransactionIsolationLevel:serializable
Any suggestions on increasing performance? Any switches/options that I can use?
Thank you
Tagged:
Answers
The only help article I am aware off that may help is available here.
What exactly appears to be slow?
You can set the logging level to verbose by adding the following switch to your cmd line syntax:
/LogLevel:Verbose or using the alias /log:verbose
For further information on logging and log files seen this help article.
Hopefully the log file will provide information as to what part of the comparison is slow.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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
Thank you for your reply. All the available switches you can set via the SQL Compare Command Line are available in this help document. Below is a very simple example of the command line syntax using the LogLevel switch:
This will then create a log file in this path %localappdata%\Red Gate\Logs\SQL Compare
You will not be lowering the log level. The Verbose log level reports all messages in the log file. It may highlight a process that is taking some time.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.
Do you mean the DecryptPost2KEncryptedObjects option? If the answer is yes, it is set via the /options: switch using its full name /Options:DecryptPost2KEncryptedObjects or its alias dp2k.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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 !