8

i'm currently working on a asp.mvc application with entity framework as db backend which will be running on ms azure platform.

on my development machine i'm running a sqlexpress instance which hosts my development database (like i said may app connects via entity framework to it).

deploying the database schema from my local sqlexpress to sql azure is pretty easy via the entity framework database generation wizard (for whatever reasons the wizard always wants to create some clustered indexes which i correct manually in the generated sql file).

but i can't figure out a way to keep my data! the auto generated sql script always dumps all my tables and creates new ones...thats ok for initial setup, but not to upgrade a existing database.

there must be a nice way to perform a schema update without dataloss...please help! i have already tried sql management studio (r2) and SQLAzureMW (available on codeplex)...but they don't do the job :(

please don't tell me i have to code my own tool to do that!

looking for your help

thx

Edit: here's how i do it now

I use the SQL scripts created by the EF migration wizard for my local SQL Express and modify them myself to be compatible with SQL Azure. Is less work that one might think and works perfect :)

Matthias
  • 363
  • 3
  • 18

3 Answers3

4

Have you tried to use BCP to export and then import your data? I believe you should be able to use BCP to export data from your SQL Express instance into a file, and then import data from the file into SQL Azure. The SQL Azure team has a blog posting that describes using BCP with SQL Azure - Link.

Additionally, in the future, the upcoming release of SQL Azure Data Sync CTP2 might be able to help you out.

Out of curiosity, what problems where you having with SQLAzureMW?

Glorfindel
  • 21,988
  • 13
  • 81
  • 109
mcollier
  • 3,721
  • 15
  • 12
3

This sounds vary similar to this question, the only answer to which is "wait for the next version of entity framework". I'll admit that I don't use EF, but I make my changes to tables the old school way with SQL Server Management Studio and scripts. ALTER TABLE FTW.

EDIT: If you don't have access to SQL Server Management studio, the new version of the SQL Azure portal includes a Silverlight based application that allows you to run queries and scripts

Community
  • 1
  • 1
knightpfhor
  • 9,299
  • 3
  • 29
  • 42
  • 2
    If you ahave SQL server 2008 R2, you can use the admin studio in that release to mount SQL AZURE databases directly. – MikeJ Jul 19 '11 at 23:23
3

RedGate is famous for SQL server synchronization and data synchronization for deployment purposes.

They have a v9 beta out of their DataCompare and SchemaCompare products that are compatible with SQL Azure. I've been using both successfully and like them alot.

They are pricey when purchased, if you are a small business.

http://www.red-gate.com/Azure

Igorek
  • 15,716
  • 3
  • 54
  • 92