2 databases merge at night

External Since: Aug 27, 2008 Posts: 2

Is it possible with any version of SQL server to have 1 database in
headquarters and 1 db in a remote site and have them do a scheduled merge
everynight over the vpn connection. Both sites will access (read/write) thier
local db during the day?
Thanks for any help

External Since: Aug 27, 2008 Posts: 2

Cool thanks for your reply.What version of SQL 2005 will I need on both ends?
By the way how does it handle record entry conflict?

Thank you again

"Hilary Cotter" wrote:

> Yes, use merge replication, peer to peer replication, or bi-directional
> transctional replication and schedule the syncs to occur only at night.
>
> "exchangerookie1994" <exchangerookie1994 RemoveThis @discussions.microsoft.com> wrote in
> message news:CE333C3A-E108-4FFC-87B9-60F3ADC90ED4@microsoft.com...
> > Is it possible with any version of SQL server to have 1 database in
> > headquarters and 1 db in a remote site and have them do a scheduled merge
> > everynight over the vpn connection. Both sites will access (read/write)
> > thier
> > local db during the day?
> > Thanks for any help
>