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] "Barb Swafford" <roundsie1@flash.net> wrote in message
news:Oh3XQ%239yDHA.2576@TK2MSFTNGP09.phx.gbl...
> 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.
>
> "chris" <anonymous@discussions.microsoft.com> wrote in message
> news:00ca01c3cbdd$5cfaff30$a301280a@phx.gbl...
> > Replication isnt what you need. Perhaps a backup/ restore
> > scenario or even use bcp.
> >
> >
> > >-----Original Message-----
> > >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
> > >
> > >
> > >.
> > >
>
>