Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sean.sullivan
Starting Member
7 Posts |
 Posted - 2009-04-06 : 14:21:57
|
| I am looking at duplicating a database in another state. Both SQL 2005 servers would have a mirror of the other as for a data goes. The question is, Identities are used all over the place in the database a Primary Keys. As such, is this something I should even consider? The app is a custom app written with SQL as the backend and ACCESS 2007 as the front end. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 10:23:52
|
| Identity management is a topic by itself if you want to manually manage it. If you just need 1 way replication where your subscriber just receives the data then your setup would be fairly simple. However, if you want to a 2 -way replication (Peer -Peer replication) and allocate a range of Identities, it can get a little tricky. couple of articles that might help: http://msdn.microsoft.com/en-us/library/ms152536(SQL.90).aspxhttp://www.simple-talk.com/sql/database-administration/the-identity-crisis-in-replication/Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
sean.sullivan
Starting Member
7 Posts |
Posted - 2009-04-07 : 14:25:15
|
| Both databases would need to be exactly the same. But with all the identities, I am not sure if this is going to work. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 14:49:22
|
| Yes.. thats fine.. will you have users updating both systems or just one? Is one of the just for reporting purposes?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
sean.sullivan
Starting Member
7 Posts |
Posted - 2009-04-07 : 14:54:27
|
| Both systems will be updated, the customer wants to have both databases in sync. However, the internet connection can be flakey |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 15:00:13
|
| I am rephrasing the question... will both systems be updated(or have data inserted/modified) simultaneously by users?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
sean.sullivan
Starting Member
7 Posts |
Posted - 2009-04-07 : 15:03:00
|
| Both systems will be modified, updated, added and deleted. Pretty much clones of each other. Hope that helps. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-04-07 : 16:24:34
|
| You need to test out Peer-Peer replication. And you will need Identity management. You need to allocate a range of values to each server so they dont duplicate an Id and start failing. The links I provided should give you a good start.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Replication of two databases