What is the difference between bulk copy (bcp) and bulk insert?
Is there a switch to export all of the data in all of tables in a database for bcp?
views:
354answers:
1
+4
A:
- bulk copy is an utility program: bcp.exe
BULK INSERTis a Transact-SQL statement.
bcp.exe uses BULK INSERT to do its job. It's the same relation that the one between sqlcmd.exe (a tool) and SELECT (a statement).
There is no 'switch' to export all tables in a database. There is however an export and import wizard which is based on SSIS, not on bcp.
Remus Rusanu
2010-01-03 06:26:10
tanx remus, is there any switch that override some of data in destination database?
masoud ramezani
2010-01-03 06:35:19
No. Your question indicates that you need to design an ETL job using SSIS, not a bulk insert.
Remus Rusanu
2010-01-03 06:39:27
can you describe ETL more for me?
masoud ramezani
2010-01-03 06:54:22
See http://en.wikipedia.org/wiki/Extract,_transform,_load and http://technet.microsoft.com/en-us/library/ms141026.aspx
Remus Rusanu
2010-01-03 06:57:33
thank you very much Remus.
masoud ramezani
2010-01-03 07:01:25