Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Database Replication and updates

Posted on 1998-09-02
5
214 Views
Last Modified: 2010-03-19
Greetings,
My company has a large SQL Server based app running over a local network. We are in the process of moving some staff to another building. This application needs to be available to a number of people (30) on both sides. The connection for the next few months will be very slow, ie T1.

My solution is to use SQL Server replication with three or four hour intervals. New site as publisher and distributor machine and present site as subscriber, but both sides will be making changes to the same table and possibly records. New site primarily adding new records and present site primarily updating records.

My question is this:

How do I handle the replication so that records entered on the subscription machine are not overwritten with the published data. Is this an SQL server setting or am I going to have to write an sp or something? If an SP or other method is involved a sample would be appreciated.

Thanks,
Brad

0
Comment
Question by:bhummel
  • 3
  • 2
5 Comments
 
LVL 2

Accepted Solution

by:
connex earned 100 total points
ID: 1089895
If you want to have always the same datas on both servers the only way is to make bidirectional replication. (Which must be done by hand in 6.5, see the SQL Books for an example)
In 7.0 just make the Distribution a Merged Distribution.

If you need further help with bidirectional Replication contact me via email (us@datapec.datagroup.de), i have set it up quite some times now, and know about a lot of traps in there .)

0
 

Author Comment

by:bhummel
ID: 1089896
Actually what I am going to do is: Use the current server as a Report Server Read-Only and any updates will be done through the new server over the T-1 line. The New Server will then Publish any updates to the Existing Server(Subscriber). This gives us full redundancy on both without the maintenance and coding issues involved with bi-directional replication.

Thanks for your help. If you could e-mail me a real world example that would be great.

Thanks,
Brad
0
 
LVL 2

Expert Comment

by:connex
ID: 1089897
I have implemented exactly that using triggers. I will explain
via email on monday (have to go for a weekendtrip now), as it's a bit lengthy.

0
 
LVL 2

Expert Comment

by:connex
ID: 1089898
Aeh reminds me that i don't have your email yet .)
Just send me a short email that i get your address please

0
 

Author Comment

by:bhummel
ID: 1089899
bhummel@criimi.com.

Thanks for your help
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Multiple functions in SQL select statement 4 27
Powershell v3 - SQLCMD 3 26
SQL Server 2008 R2, need a pivot/cross tab query... 4 26
job schedule 8 16
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question