Activity overview
Latest activity by msurasky
fllouw wrote:
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted objects was checked (it is checked by default). Unchecking the option to decrypt encrypted objects solved the performance issue.
Thanks,
Francois
Thanks fllouw, that also fix the performance problem in my case as well. Now the only question that remains is why option to decrypt encrypted objects causes so much overhead, but that is a question I will leave for another day.
Cheers! / comments
fllouw wrote:
An update: I found the reason for the performance difference. The large database had a single encrypted object (a 5-line stored procedure), and the option to decrypt encrypted obje...
Update:
I left the snapshot generation to run a few more hours and apparently after all these time it finally finished.
I'm not sure how many hours it took in the end or whether it really got stuck at some point in time or it was just SUPER slow.
Having said that, you replied asking me to provide the log. I have no problem in doing so but I have no idea where it is located.
If you point me to the Log file I will update the call with a copy of it. Unfortunately I can't attach also the screen shot because, as I said, the process completed after a few more hours.
Regards, / comments
Update:
I left the snapshot generation to run a few more hours and apparently after all these time it finally finished.
I'm not sure how many hours it took in the end or whether it really got stuck...
SQL Compare hangs at "Reading object text"
Hi all,
I am trying to generate a Snapshot of a database located in a remote location. I am runing SQL Compare 10.3.
I have verified that SQL Compare has no trouble in seeing that server (and the d...
Will Do
Thanks James! / comments
Will Do
Thanks James!
SQL Compare command line dependencies
Hi,
I'm trying to compare a database in a SIT environment with another database in the User Acceptance one.
The problem is that
1) This two networks do not talk to each-other and they never will (n...
Disregard this problem... I'm not sure what has happened but I can't reproduce the behavior I posted in my previous post anymore.
I thought the problem was constant but apparently it is erratic and I can no longer see the prompt missing when closing a modified projects.
Thanks! / comments
Disregard this problem... I'm not sure what has happened but I can't reproduce the behavior I posted in my previous post anymore.
I thought the problem was constant but apparently it is erratic and...
Selection changes not saved when closing SQL Compare
I'm not sure if I'm missing something or there is a problem with the tool. I have looked around in this forum and no one have reported it before so I'm not sure what to think...
A few days ago I wa...