May 23, 2004 at 2:26 am
Dear all,
Im quite new to SQL Server 2000 Replication.
but i know some bascis.
I have a Central Database "LBS"
and i have some local Databases(LFS) scattered in
different locations geographically.
Both LBS and LFS are SQL Server 2000 running on windows 2000 servers.
i want to send newly inserted records from my "LBS" to all the "LFS" through Replication.
all these tables are one way syncronisation.
that means the data will always be sent from LBS to LFS and no data will be sent from LFS to LBS for these tables. i need to filter the rows that is sent to LFS by giving a Criteria. by specifying this i can send only data which is required to the specifuc LFS.
Similarly i have transactional tables in all LFS which should be updated to the LBS.
here the Transactional tables will not change in LBS and the Data will be sent one way
LFS to LBS. All the transactional tables in LBS have a KEY field with which each row will be uniquely identified. this field will not be present in the LFS tables.
how can i generate the key field value in LBS at the time of sncronisation.
anybody can give me suggestions on how to do it?
Thanks and Rgds
Ramesh
May 23, 2004 at 6:22 pm
May 24, 2004 at 9:03 am
Regarding your requirement to route data to specific LFSs, you should be able to do this with merge replication's dynamic filtering. Take a look at the Books Online 'dynamic filtering' topic.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply