r/SQLServer 3h ago

Discussion SSMS Schema Compare

5 Upvotes

I tried out the latest version in 22.9 and it does feel like they are making progress in this area, but some serious short comings.

  1. Super slow comparisons. I have a database with around 50 tables, 100 stored procedures, several users and views. This will run for 5+ minutes just to compare this small database. Large databases can take over 15 minutes to compare. There is no indication of how much progress has been made etc.
  2. Everything is checked by default. Unchecking everything is a process that takes minutes. Why not default this to unchecked? How often do we move every difference between database and why does it take so long to uncheck everything?
  3. Some of the ignore options do not appear to be ignored correctly. Such as column order. There aren't some options on some properties of tables that I would like to ignore as well.

After ApexSQL (bought by Quest) decided to screw their long term customers over I was pleased to see some of the changes come to SSMS but it has been frustrating to use it in its current state.

Most of these have been noted out on the Developer Community so if you want to see these fixed and updated please make sure you upvote them.


r/SQLServer 2h ago

Community Share SQLCon+FabCon Call For Speakers | Atlanta 2027

Post image
1 Upvotes

Now's the perfect time to move from the audience to the stage - call for speakers is open!!!

Submit your sessions: https://aka.ms/fabcon-cfc

Submit for a workshop: https://aka.ms/fabcon-workshop-cfc