hi...i was instructed by my boss to do some research on one replication scenario and come out with a solution.
The scenario is.. theres a main db (big one) will push data to over 60 small db and the system on normal basis will push only the differences to those small db. Plus theres an option where the system can do drop and re-create tables (snapshot replication).
I have been looking at DTS, Replication Wizard and Trans-SQL ...do know which ones to choose...all of them got pros and cons..and performance is very important..please help...
thanks