sql server replication: Temporary Offsite Database -- sql server replication

Temporary Offsite Database

cmay
8/9/2006 3:54:04 PM

sql server replication:

A database we have running SQL Server 2003 will need to be copied and
taken offsite on a laptop for about a week. While the laptop is out of
town, both SQL Servers, the one in the office and the one in the field,
will both continue to operate.

They will both get new Customers, WorkOrders and WorkOrderItems, all of
which are related and use Auto Increment IDs.

Is there something with SQL Server replication that I can use so that
when the laptop comes back we can merge the data back into 1 database?

Re: Temporary Offsite Database

Hilary Cotter
8/9/2006 10:30:04 PM

Merge replication with automatic identity range management is ideal for
this.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]