Migrating Database schema to SQL Azure using DAC
DAC Fx is a Data-tier Application framework that helps developer to deploying, versioning and migrating databases. We can use DAC to migrate database to SQL Azure.
In this blog post, I am going to show the simple steps to migrate a database schema from SQL Server 2012 to SQL Azure using DAC utility.
I have a database named “Currency” with two tables (Currency, CurrencyRate). These tables are copied from AdventuresWorks2012. So, It is easy for you to create a database with these tables in your machine.
In this demo I will be extracting DACPAC file from source and Deploy it in SQL Azure.
Step 1: Extract DAC from the Source database.
Step 3: Open SQL Azure portal
We have now migrated the Currency database schema to SQL Azure.