Home > SQL Azure > Migrating Database schema to SQL Azure using DAC

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.

Implementation

prerequisites

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.

pic1Step 2: Create BAC Package file using Extract DAC wizard.

pic2Click Next

pic3Select path for BACPAC file storage and Click Next

pic4Validate the settings and click next

pic5We have successfully created the DAC Package file. Click Finish now.

Step 3: Open SQL Azure portal

pic6Click Deploy button

pic7Select the DAC package file and click submit.

pic8Step 4: Go to Administrator page and click Refresh button.

pic9

We have now migrated the Currency database schema to SQL Azure.

Advertisements
  1. No comments yet.
  1. January 20, 2013 at 11:25 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: