SQL Server Performance Forum – Threads Archive
Which method is bestHi 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?
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 ?
THe basic approach of this project will be suitable with Replication, I feel merge replication will be nearest match. Refer tohttp://www.databasejournal.com/features/mssql/article.php/1438231 link & books online for further information on replication topic. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
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.