Activity overview
Latest activity by AlexK
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...
I am reopening one and the same project every time. / comments
I am reopening one and the same project every time.
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...
Why SQL Compare does not remember my settings?
Every time I compare my development database against a copy of production, the roles are always checked, even if I unchecked roles the previous time. This is annoying: roles in production have some...