Compare and Synchronize the SQL Server Db with Azure SQL Db

moondaddy 911 Reputation points
2022-01-10T22:45:17.953+00:00

I have SQL Server 2019 installed on my local dev pc and created a visual studio 2022 db project for it. now I want to synch the schema to an Azure SQL DB. I ran schema compare which ran fine but the update button in VS is disabled.

What do I have to do to enable the update button?

Thank you.

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,714 questions
Accepted answer
  1. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-01-11T03:11:13.283+00:00

    Hi @moondaddy ,

    >From doing the data-compare, how would I generate a script?

    Generate Script – with a click on the Generate script button, a script is generated and shown under the newly opened panel which named is based on the target database name.

    163679-screenshot-2022-01-11-110105.jpg

    Please refer to this blog How to compare two SQL databases from Visual Studio to get detail steps.

    > But I would still like to know how to configure this so the Update button is enabled.

    It seems that any errors prevent the UPDATE button from showing. Please check in Error List whether you have any error or waring.

    Refer to this similar thread Update target button is disabled after schema comparison.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest