Import or export database to others media??

[May24]

Hie,

I am still new in using SQL server. I would like to know how can I import or export a database to others media such as floppy disk using SQL Server 2000.

I had tried this before using SQL Server 7.0 but i failed to do so in SQL server 2000.

 

[tlbroadbent]

When you say you want to export a database, what do you mean? Are you exporting data from tables or database objects or what? What format(s) are you attempting to export? What problems have you encountered - any specific error codes? Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[mjmr7]

what is BCP and DTS?

 

[May24]

What i mean here is exporting the database object using the import/export wizard... how am i going to specify the destination to floppy disk?

 

[tlbroadbent]

I'm still not certain of your meaning when you say you want to export an object. If you mean you want to create a SQL table, view or procedure on a floppy then the answer is you cannot do that.

You can export the data from a table or view to a text, Excel, or other type of file on floppy disk. You just need to set the destination path in the wizard after choosing the type of file you are exporting to.

If you provide more detail, we may be able to provide more help. Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin