Schema Compare in Azure Data Studio delay when Include or Exclude objects

Question

While choosing objects in Schema Compare in Azure Data Studio with the help of the Include checkbox we experiencing a delay, so when you press Apply too early the selection is not effective yet and all objects with differences are updated. You get a warning that recalculation of dependencies can take some time, but there is no clear signal when exactly it is finished and when you can Apply the changes.

Answer 1

Hi Tigor Sinuraja,

Welcome to Microsoft Q&A forum.

As I understand, you are facing delay when doing schema compare in Azure Data Studio.

Could you please share steps taken for this in ADS?

Also, any relevant screenshot of the page would help.

Ensure that you are using the latest version of Azure Data Studio. Microsoft regularly releases updates and improvements to the tool, including enhancements to the schema compare feature.

Thanks

Answer 2

Hi Tigor Sinuraja,

Thanks for the reply.

As you have mentioned that Target is not DB, it is SQL Project, could you please try below to update an existing SQL project from a database:

1. Install both the Schema Compare and SQL Database Project extensions.
2. From a Database dashboard select the Update Project from Database option in the toolbar.
3. Select the existing SQL project and the desired file structure for new objects.
4. Choose View changes in Schema Compare to review the changes before applying them to the SQL project.

Reference:

https://learn.microsoft.com/en-us/azure-data-studio/extensions/schema-compare-extension

Hope this should help.

Let us know if you face any issue.

Thanks