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

Tigor Sinuraja 5 Reputation points
2024-03-12T10:27:37.44+00:00

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.

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,751 Reputation points Microsoft Employee
    2024-03-12T11:05:14.8266667+00:00

    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

    0 comments
  2. ShaktiSingh-MSFT 13,751 Reputation points Microsoft Employee
    2024-03-13T04:53:59.0433333+00:00

    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.

    User's image

    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