How to export a table in native format? 1

[bluecjh]

v.2000

Using DTS or other approach

How can I export a table in native file format?

Seems an obvious one to me but the export wizard
doesn't offer this.

Thanks

Chris

 

[bluecjh]

I should add, I want to export to a file not directly
to another server.

Chris

 

[Catadmin]

You'll have to use the BCP tool in order to use native format.

Storing information in native format is useful when information must be copied from one instance of Microsoft® SQL Server™ to another. Using native format saves time and space, preventing unnecessary conversion of data types to and from character format. However, a data file in native format cannot be read by any program other than bcp.

And I'm not sure it'll work effectively if you're trying to copy it to a file that is not another SQL Server. MOF, I don't know that you can use Native if exporting to a non-SQL file type. From the quote above, BOL seems to say that you can't.



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"

 

[bluecjh]

Sounds like a definitive answer
Catadmin
Thanks

Chris

 

[Catadmin]

Anytime. @=)



Catadmin - MCDBA, MCSA
"Just because I'm paranoid doesn't mean the universe *isn't* out to get me!"