2 databases merge at night

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

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" wrote in
> message news:CE333C3A-E108-4FFC-87B9-60F3ADC90ED4-at-microsoft.com...
> > Is it possible with any version of SQL server to have 1 database in
> > headquarters and 1 Database in a remote site and have them do a scheduled merge
> > everynight over the vpn connection. Both sites will access (read/write)
> > thier
> > local Database during the day?
> > Thanks for any help
>

Thank you Hilary

"Hilary Cotter" wrote:

> Merge replication will handle the conflicts. For peer to peer you will need
> enterprise edition. For merge it can be standard or workgroup on the
> publisher and express on the subscribers.
> "exchangerookie1994" wrote in
> message news:77AF03CC-AFAC-4286-AE0D-CA18886AD0FB-at-microsoft.com...
> > 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" wrote
> >> in
> >> message news:CE333C3A-E108-4FFC-87B9-60F3ADC90ED4-at-microsoft.com...
> >> > Is it possible with any version of SQL server to have 1 database in
> >> > headquarters and 1 Database in a remote site and have them do a scheduled
> >> > merge
> >> > everynight over the vpn connection. Both sites will access (read/write)
> >> > thier
> >> > local Database during the day?
> >> > Thanks for any help
> >>
>