Copy data to OLTP dabatste | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Copy data to OLTP dabatste

I want to copy my data from my present environment to an OLTP database. Only a few tables will be copied. What should be the best approach to do this. Thanks, StarWarsBigBang
Explain your requirement with more information, with the above type of question will get you answers to look into DTS or BCP in this case.
If you have any specific requirement to copy the data, then ensure to explain your reasons to do so. Otherwise search through forums for similar topics. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>