Geek Answers Handbook

EF Code Sync Azure SQL First

I am trying to find the best way to synchronize / migrate EF Code First databases from localhost to SQL Azure without using EFCF Migrations. I know that I could use this approach, but I want to look at different, less automatic options.

The following process or its variants is the one I would like to execute:

  • Development locally, allowing EFCF to build a database on a local hosting
  • Sync a local database with a scene database on SQL Azure using some tool
  • Running tests in an intermediate environment
  • Synchronization / migration of the database (local or stage) to the production database on SQL Azure

Using MySQL is a breeze. MySQL Workbench can synchronize the schema model with the corresponding database, simple and simple. In this case, I do not have a schema model as such, but the database on the local host created by EFCF can be considered by the chart.

What tools are available for this task? Can this be done using SSMS?

Update: how I did it : After a prompt from Craig to use the Visual Studio 2012 Database Project, I did the following:

  • Created an empty VS 2012 database project and installed its target platform for SQL Azure
  • Was the new schema mapped, source database = local db database and target = database
  • Target updated. This led to the acceleration of the database design.
  • Was there a new project source = database and target = SQL Azure stage db
  • Target updated. This has led the SQL Azure db phase to increase in speed.

This is exactly what I was looking for

+4
source share
2 answers

Visual Studio 2012 database project can do this, I do this all the time.

+3
source

It's not free, but Red-Gate SQL Compare will handle schema replication

+1
source

More articles:


All Articles