Posted by Benzine on 11/24/06 22:14

Thanks for your reply.

This is the situation regarding the software security, all users have
read only access to all data and have the ability to create new
entries, but sales people can only modify/delete their own.

There is also an additional 2 levels of security applied, sales
managers & sales directories.

Sales managers can modify/delete their branches/states sales
information & sales directories can modify/delete their countries sales
information. (As this application is used internationally.)

I have been doing some further research and have concluded that merge
replication would be best suited here while applying identity ranges
for tables containing identity columns for each sales staff to
avoid/minimize conflicts when syncing. Could you please let me know if
there is anything else I have missed?

Also another quick question, when setting up each
subscription/salesperson do I have to replicate all tables that get
used in the application or only the ones that will be modified by the
subscriber/salesperson?

• Next in forum: Re: DTS - Need to Set Destination Filename dynamically
• Prev in forum: DTS - Need to Set Destination Filename dynamically
• Thread view: Re: Which Replication Method To Use

[Reply to this message]