Loading

Load large data to the SQL server database

Manish Sharma

14y2k

Hi Friends

How do we load large data to the SQL server database?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chetan Kumar14y ago
Hi,

U can have more options to load data to SQL db.
1) SSIS package
2)Import/Export Method
3)Bulk copy
4)BCP command

Sandeep Singh Shekhawat14y ago

Use Bulk Copy

BULK INSERT bulktest..t_float FROM 'C:\t_float-c.dat' WITH (FORMATFILE='C:\t_floatformat-c-xml.xml'); GO


http://msdn.microsoft.com/en-us/library/ms188365.aspx

Thanks 
Sandeep