SQL Server Performance

Which method is best

Discussion in 'Performance Tuning for SQL Server Replication' started by sandhya, Nov 2, 2004.

  1. sandhya New Member

    Hi all,

    I am required to get data about the projects from all the project managers in 12 offices to the corporate office for the senior management within the United States. Which do you think is the best method - replication/bcp/DTS?
  2. Med New Member

    It depends what you project to do with the collected data.
    If your intention is only data collection, the fastest way remains BCP.
    If your intention is to integrate them in one place, the safest way is replication.
    Can you tell us what is your goal ?
  3. satya Moderator

  4. vbkenya New Member

    Your needs and resources will actually influence your decision:

    Replication - If you want a fully automated and easy to set up merge process and you have the bandwith/infrastructure/expertise to support it. Remember to choose the different replication types and models appropriately to reflect the frequency and amount of data changes at the branch offices.

    DTS - If you need to somehow change (Transform) some/all of the data before aggregation. It is irresponsible to use DTS just for bulk copying data. I would not advise this for highly dynamic data. Things could get complicated pretty fast.

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com

Share This Page