Save and load data with schema in MSDE

Hi,

How can I save and load data with schema in MSDE in the quickly way? I need to do this in 5-10 second for 5 millions of rows.

Thank's
Alexei

Please take a look at the BCP command-line utility in Books Online. This allows you to export/import large amounts of data. There are also TSQL versions of the BCP command but only for the insert portion. See BULK INSERT topic for more details.|||

Hi,

It's nice but it works slowly. When I put 1,5 millions of rows it takes 40 seconds and it's it too much.

Thank's
Alexei

|||

Please take a look at the link below for some tips onhow to optimize bulk load:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx

You also realize that the bulk insert will only be as fast as your disk system. It is mostly an I/O bound operation.