Comments
Sort by recent activity
I am reopening one and the same project every time. / comments
I am reopening one and the same project every time.
SQL Compare 6.0.0.1410.
I just reproduced it again.
I started SQL Compare, selected an existing project, and again the standard roles such as db_owner are unchecked as they should, but all the roles which I created, such as DW_Reader, are checked again. I unchecked the roles, ran synchronization wizard, and closed the app. When I reopened it like 10 seconds later, all the roles that I created were checked again.
I am not sure in which scenarios are most of your users using SQL Compare, but when we compare our development databases against copies of our production ones, we never synchronize user-defined roles, that means we always override the defaults.
I'm leaving for PASS in Denver, so the next time I'll be able to reply might be next Monday. / comments
SQL Compare 6.0.0.1410.
I just reproduced it again.
I started SQL Compare, selected an existing project, and again the standard roles such as db_owner are unchecked as they should, but all the role...
Boris,
Hundreds of tables/procedures/triggers is no big deal. I compare such databases all the time and it rarely takes more than a minute or two. My workstation is
Quad 1.8 Hz Dual Core AMD Opteron 2210
4Gb memory
I have a dedicated workstation for Red gate tools, so I don't run anything else when I run SQL compare. Let's troubleshoot your delays. Try running Profiler and figure out which queries are slow. Try running Compare against only test servers that are not busy with anything else.
Alex Kuznetsov
SQL Server MVP / comments
Boris,
Hundreds of tables/procedures/triggers is no big deal. I compare such databases all the time and it rarely takes more than a minute or two. My workstation is
Quad 1.8 Hz Dual Core AMD Optero...