Please help..

• amirx

  SSC Rookie

  Points: 44

  More actions

  January 23, 2003 at 12:07 am

  #80621

  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

• January 27, 2003 at 12:00 pm

  This was removed by the editor as SPAM

• harim

  SSC Journeyman

  Points: 98

  More actions

  February 6, 2003 at 4:22 pm

  #448313

  Hi:

  Snapshot looks like a good fit

  It will be good to have the subscribers pull the subscription from the MainDB --- this way there isn't too much of a load on onse server.