SQL Server Data Tools

SSDT is a nice simple way to compare your local SQL database with your SQL Azure database. You can then execute the script it makes inside Visual Studio to update you Azure database.

Normally I would use database first but in this instance I had stored procedures to run and used database first. This meant could not use migrations to merge the schema changes.

Below are the visual steps.

  1. In SQL Sever Object Explorer select the db and right click to expand and choose data comparison.

  2. Choose the Azure DB and enter your credentials and select compare. This may take a minute but will show the differences in the databases.

  3. The you can select update to run the scripts. But in my case I had to turn off “Block on possible data loss” as I was deleting tables knowingly.

  4. Select update to run the scripts against your Azure database.

Tweet Post Share Update Email RSS

Hi, I'm Duncan Hunter, I write this blog, work for SSW as a Software Architect in Australia, create courses for Pluralsight, travel the world speaking at events and training technology professionals.