Urgent Using BCP utility

[bnath001]

I have .DAT file (data file of SQL server database) someone suggested me to use BCP utility to upload the data into a newly created SQL server database.

Does anyone have any documentation for using the BCP utility?

Any help will be appreciated.
thank you
nath

 

[Ruairi]

the bcp utility is for loading data from text files to sql server. i dont think you can use it to upload a .dat file. If you have all of the dat files for the old database, including master.dat you can do a new install of sql server and copy all of the dat files to the correct directories, owerwriting the .dat files created by the install, although this method is not officially recommended by microsoft i have done it successfully.

 

[Waynest]

I couldnt say whether bcp will do what your asking, I've only used it for text files, but there's a comprehensive document on how to use it that you can download from the microsoft web site

http://www.microsoft.com/TechNet/sql/manuals/admincmp/75517c02.asp

I figure you'll need to use bcp before long anyway, its sort of essential.