Is there any article/help/doc on how to sync data between MSDE2000? I have installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
Thanks
Look in the BOL about SQL Server replication.
Depending on your synchronization needs, there are a variety of options. If
you don't have the Developer's Edtion of SQL Server then I recommend that
you get it so that you can use EM to develope any replication DTS packages
you may need.
Jim
"Henry" <anonymous@.discussions.microsoft.com> wrote in message
news:39504051-7ECA-4EC2-BF34-562271854B62@.microsoft.com...
> Is there any article/help/doc on how to sync data between MSDE2000? I have
installed MSDE on two XP machine, would like to sysnc the data bwteeen them.
> Thanks
|||Thanks, Jim.
I try to EM config the replication, use one machine as distributor and publisher, but it kept tell me can not connect to server because 'distributor_admin' is not defined as a remote login at the server. Do you know how to define this user? I tried creati
ng db and windows user, wouldn't work. These two machines are in a workgroup.
In my application, one MSDE(1) is collecting data, the other MSDE(2) get the data published from the (1) and read the data only. I plan to use (1) as publisher & distributor, (2) as subscriber. these two machines are not always online. Which way to sync i
s better, push or pull?
Henry
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment