Data Migration

[Fampofo]

Hi Guys,
We are doing a major project on data migration from a UNIX based database to SQL2000. I intend to use DTS tool as most books recommend but the project manager disagrees with me. He thinks the best way is to gather all the field names and records in one big flat file (text file) and then use a stored procedure script to copy data into SQLServer. Do any of you think he is right? if not what's the best method available. Thanks

 

[tlbroadbent]

I'd choose DTS because it is easy to use, will help you develop the import package, can perform transformations while importing and is fast. When you say "one big flat file" do you mean all the data in one file - even data if the destination is different tables?

Does the project manager intend to use XML? How is he planning to load the data into SQL server if the file contains different record types? Without more info, it is difficult to understand the reasoning. However, BULK INSERT in a stored procedure can also be used effectively though development time may increase. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.