database – I am using MS Visual Studio 2022 Schema compare for a SQL Server project but it’s very slow 45+minutes


I am using Visual Studio version 2022 to develop and maintain an application database.

The database has over 1900 tables,1600 stored procedures, 1600 views, 200 triggers, 120 functions…
It takes approximately 45 to 60+ minutes to do schema compare.

Is there a way to accelerate the schema compare or to partition the database project so that it more manageable when running schema compare?

I have tried:

  • Running Visual Studio on a beefy virtual desktop
  • Run a trace to create plan guides which did help for the first schema compare after creating the plan guides and then it reverted back to it’s usual 45+ minutes to complete
  • Turning ON/OFF “USE HARDWARE GRAPHICS ACCELERATION”

It’s still taking too long.

Leave a Reply

Your email address will not be published. Required fields are marked *