Using the Entity Framework with multiple identical databases

Question

I have a system where there are two identical databases. One is for back of house work where data is imported, edited generally worked on. Once the data in the first database is as required it is coped to the second database, which is used to drive a public facing (read only) site.

So once a month, or so I will need to push data from database to another. I'd like to drive all this with EF, is that reasonable, can EF do this kind of thing, or will I get stuck part way down the line?

I could, but I want a user to click a button on a web page and see some sort of progress indicator. Even doing it via a stored procedure that writes to some sort of status table would enable me to report to the user how far it's got in the process. — ilivewithian
– ilivewithian, Commented Aug 27, 2010 at 8:51

jeroenh · Accepted Answer · 2010-08-26 21:07:37Z

2

It's probably doable, but frankly, EF (or any other ORM) is not really suited for this kind of task. If you do decide to implement your synchronization tool with EF, at least make sure to turn off change tracking.

I wouldn't dismiss Yuri's suggestion (simply using a scheduled backup/restore), if the databases are really identical. It's certainly the easiest to implement!

Another solution would be to use a database synchronization tool, like Sql Server Integration Services.

edited Aug 26, 2010 at 21:07

answered Aug 26, 2010 at 18:10

jeroenh

26.9k11 gold badges77 silver badges107 bronze badges

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

Collectives™ on Stack Overflow

Using the Entity Framework with multiple identical databases

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related