October 2, 2003 at 11:13 am
hi all expert,
i have a SQL server 2000 running on machine1 and one MSDE running on machine2.
on machine2 i've create a program listening to communication port to receive data and save the data into local MSDE.
i need to syn MSDE's data back to the SQL Server machine every one minute.
if machine1 delete data then machine2 will delete also, if machine1 insert or update then it willnot affect the machine2.
one more thing is if machine1 down, machine2 will keep the data at MSDE, until machine1 is down, data will be syn back tp machine1.
what replication type is more suitable to the condition?
The communication port will receive almost 2 data per second and save into MSDE.
Please help?
October 6, 2003 at 7:38 am
I Would use transactional, running the distribution agent by every hour, using only delete stored procedures. And using a retention period long enough to keep the transactions in publisher until both servers are up.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply