CODEWITHSUNDEEP
sqlazure
Toby Sharp
Toby Sharp

Reputation: 2059

How to move data between Azure SQL database instances

I have a simple Azure website and Azure SQL database. I have now created a new (empty) Azure SQL database and I want to copy the contents of the old database into the new one. The data is only a few kB in size but it would be a pain to do it manually. What is a quick and easy way to do this, using simple tools like Visual Studio and Azure portal?

So just to be clear I want to copy all tables and rows to the new DB.

Upvotes: 1

Views: 1168

Answers (2)

Toby Sharp
Toby Sharp

Reputation: 2059

It turns out you can do this using the Azure portal.

On the original database, choose Export. You need a storage account in the same region as the database for this.

After exporting the database to a .bapac file, choose New / SQL Database / Import and point it to the bapac file. If this is in a different data centre, it will incur data bandwidth charges.

Very simple and this worked great; just a little difficult to find at first.

Upvotes: 3

Thiago Custodio
Thiago Custodio

Reputation: 18387

When I need to such operation, I use Sql Server Data Tools. It`s a plugin for Visual Studio that allow you to copy data, schema and migrate from one version to another.

http://blogs.msdn.com/b/ssdt/

Upvotes: 1

Related Questions