1

We have a MS sqlproject where a database project references multiple vendor databases. In other projects, schema compare is very fast, but in this project, schema compare has gotten as slow as 20 minutes. That's unuseable.

What could be causing this? How can I diagnose?

MattK
  • 1,521
  • 1
  • 12
  • 25
  • 1
    Schema compare speed depends on the number of objects that are present in a database. If for example a database has thousands of stored procedure schema compare can be extremely slow. – Paolo Costa May 02 '15 at 15:33
  • 1
    Attach SQL Profiler to see what's being executed. That can give you a hint. Or, use PerfView to profile devenv.exe and see what function names are on the stack. – usr May 02 '15 at 16:51

0 Answers0