5

I want to transfer a local SQL Database to Microsoft Azure. There are files stored in the db, so the db is about 300MB in size.

From SQL Server Management Studio I tried the following:

Tasks->Generate Scripts

I was able to create the .sql script but couldn't load it.

I also tried the

Tasks->Deploy Database to SQL Azure...

but after about 30 mins, it crashed.

Any ideas?

Improve this question
0

1 Answer 1

Reset to default
10

You should use the Azure migration wizard instead of using SSMS create script.

How to: Use the SQL Azure Migration Wizard

Behind the scenes it uses bcp to transfer your data to Azure.

For the future, SSMS is not meant to handle large .sql files. Even a 1 or 2 MB file will crash SSMS. Instead you should use command line tools like sqlcmd or bcp - depending on your needs.

Improve this answer
1
  • 1
    Very cool! My 300MB db was migrated in 18 minutes and 10 seconds. Thanks a lot
    – Timothy
    Commented Oct 13, 2015 at 16:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.