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 |
|
henrikop
Constraint Violating Yak Guru
280 Posts |
 Posted - 2007-05-04 : 11:07:27
|
| I have a company with 5 offices connected with a dedicated line (500+ employees).They have five databases, one in each office.Now they want a new application which will replace the old (VB6 on MySQL will now be VB.NET 2.0 with MS SQL Server 2005).The want all the data availiable in all the offices. We will still have 5 databases in 5 offices, but all with the same data.Sometimes the dedicated line is lost.Now I have a few questions:Will the database be still running while a line is down?Will the database be still running if replication is of type Merge (instead of continuesly).Is it good practice to use unique identifiers versus Numeric keys?Is it good practice when the application uses the "master" database to save global things like "Suppliers" and the local database to add and change Orders?Do you have some recommended reads?Thx for your time!Henri~~~~There's no place like 127.0.0.1 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-04 : 11:17:05
|
1 and 2. merge replication has the highest autonomy but lowest transactional consistency. meaning the server can be stand alone but not all transactions from other sources willl be available.if all your servers can have updates on them you can use multiple publishers and multiple subscribers replication.3. i don't see why not4. no.5. BOL, google  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 11:52:44
|
| Take look at peer to peer replication. |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-05-06 : 15:13:49
|
| For Peer to peer replication, regional updates should be better and there is no conflit resolution in peer to peer replication. You have to have Enterprise Editon for Peer to peer replication....where as merge replication is available in all editions...Check the following url...http://www.sql-server-performance.com/da_peer-to-peer_replication.asphttp://www.mssqlcity.com/Articles/Replic/SetupMR/SetupMR.htmMohammedU |
|
|
|
|
|
|
Is this scenario possible?