Entity Framework and Synchronizing a database solution?

Question

I currently have an n-tier application using entity framework 4.0 and we're looking at synching the contents of database between redundant servers. Does anyone have any experience on tips on how best to approach a solution?

Answer 1

From an architecture point of view, you need to consider if you want to do this at the application level or the database level.

At the application level you could write to both databases any time you made a change.

At the database level you could use the replication tools build into the database that you use.

You could also use a 3rd party tool. There is also a sync framework available from Microsoft.