Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
2 databases merge at night
0 views
Skip to first unread message
exchangerookie1994
Aug 27, 2008, 3:51:02 PM8/27/08
to
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
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
exchangerookie1994
Aug 28, 2008, 6:38:02 AM8/28/08
to
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?
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" <exchanger...@discussions.microsoft.com> wrote in
> message news:CE333C3A-E108-4FFC...@microsoft.com...
exchangerookie1994
Sep 8, 2008, 5:58:01 AM9/8/08
to
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" <exchanger...@discussions.microsoft.com> wrote in
> message news:77AF03CC-AFAC-4286...@microsoft.com...
0 new messages