Groups | Blog | Home
all groups > sql server replication > december 2003 >

sql server replication : replication between servers not connected


chris
12/26/2003 10:23:30 AM
Replication isnt what you need. Perhaps a backup/ restore
scenario or even use bcp.


[quoted text, click to view]
Barb Swafford
12/26/2003 10:50:40 AM
we want to replicate between 2 servers that are not connected, temporarily,
for a few months. ideally i would like to carry the information back and
forth on a cd, either writing information directly on the cd, or writing on
the hard drive and then coping a file to the cd. can anybody help? or point
to where this is spelled out how to do.

thanks

Barb Swafford
12/26/2003 11:38:51 AM
we are trying to combine data from both servers. we had merge replication
working previously, to combine timeclock events, etc. and at some point we
will be able to go back to that. meanwhile we need a way to merge data from
both servers. if we backup/restore we would wipe out data. both servers are
writing data for the other server to see.

[quoted text, click to view]

Allan Mitchell
1/4/2004 11:09:13 AM
So the scenario is that you can take data from database1 on serverA and put
it on a CD. You carry it over to ServerB and ask it to merge with databaseB
on that server. You then take that data and what? merge it back with
serverA database1 ?

Any likely conflicts ?

If there are no likely conflicts then I would

Add triggers to each table and have them log changes to each of the tables
you want to be synced

Periodically you dump these table to text file on a CD or to a ChangesDB.
You then move this CD with the data to the other server. You can then use a
DTS routine to load the data into the other database.

If there are conflicts then you will have to build in a conflict resolution
model which will not be pretty. Merge Replication is the way forward I
think here if you could get the sites to see each other periodically.


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]

AddThis Social Bookmark Button