Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

The only way I could figure how to do it was create the schema on the localDB with code first and then manually change the database string to Azure and then run the code on Azure.. But that only gives me the schema and not the data..

Is there a better way like ? bacpac? Create a script instead? Or some other concept I am missing ?

share|improve this question
1  
Doesn't this page describe a tool which handles importing/exporting of data: blogs.msdn.com/b/sqlazure/archive/2010/05/19/10014014.aspx You're exporting data out of the local database, and importing it into the Azure DB –  EdH May 17 '13 at 1:44

1 Answer 1

up vote 1 down vote accepted

Generating a script for just data from SQL Server Management Studio should work fine, but for a large amount of data you may have to save the script into a file and run it from the command line. This method will not allow you to synchronize changes made after the initial migration.

There are some excellent professional tools for dealing with this problem. I use Redgate's SQL Data Compare to synchronise data from a local database to SQL Azure, which can either generate a script of the differences or update the target database itself.

share|improve this answer
    
they removed the built in Data Compare that Visual Studio 2010 had.. So I guess this is similar.. Ill give it a try –  punkouter May 17 '13 at 18:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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