3

I have a local database SQL Server 2008 Express and I have tables along with data in them. I want to export those schemas and data to SQL Azure database.

What I have tried in SQL Management Studio is to right-click database (contextual menu) and Tasks->Generate Scripts. But those SQL scripts were only the schema, stored procedures etc and no data is exported at all.

Then I have tried Tasks->Export Data, but there were no appropriate export types. I have seen only Flat File dump and I think SQL Mgmt Studio 2008 R2 does not support importing flat files for SQL Azure.

Is there a nicer way to export data from SQL Server as sql scripts and execute them on a remote server without using any 3rd party tools?

Improve this question

4 Answers 4

Reset to default
4

I found that SQL Azure Migration Tool http://sqlazuremw.codeplex.com/

Very handy and useful. Worked for me.

Improve this answer
Sign up to request clarification or add additional context in comments.

4 Comments

I had to comment out Microsoft.ExceptionMessageBox in Dependencies.xml to get it to run.. after that everything was smooth!
Does that work using command line or does it need User Input ?
broken link, please amend
project appears to be dead. feel free to click Edit on my comment.
2

In Tasks/Generate Scripts you can set Script Options/Script Data to be True, which should script out the data as well.

Not free, but SQL Data Compare will let you move data from on-premise to SQL Azure.

Improve this answer

Comments

0

You can try SQL Server Import and Export Wizard.

For Detailed steps reg how to do it, check link.

I have worked with it already and it works fine for both Azure and on-premises.

Improve this answer

Comments

-3

An article that comprehensively explains available options:

http://parasdoshi.com/2011/06/20/solidq-journal-article-migrating-data-into-microsofts-data-platform-sql-azure/

Full disclosure: i work at SolidQ.com

Improve this answer

1 Comment

This link goes to a page with broken link to the article in question.

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.