Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  adive on db & replication setup

Author  Topic  amerms Starting Member 2 Posts Posted - 2005-11-15 : 10:48:11 i have one erp application and one retail sales application. all the master info about customer and items are in erp which we transfer to sales application using an application. similarly, we transfer all the sales & receipt transactions from sales application to erp ( all transaction , not summary) again using application. erp and sales application is installed only at head office. now we want to install sales application at branches. the setup will be standalone, with separate sql server db at each location. the requirement is that master info about customer and items should be populated from erp to sales db at each branches and only records relevant to each branch should be loaded in sales application. and .. all the sales transaction from sales application at all the locations should be entered into the erp system (which is installed only at head office). - also -- we want to keep a mirror copy of all sales db at head office. -- also -- we want to have a db which has all the data from all the branches (master and transaction) **** how to setup this... suggestions are requested . thanks in advance Smile ... it increases your face value !