RE: Need to export one table to another database in a different server/db

SSC Guru

Points: 1003894

March 1, 2015 at 5:07 pm

sql-lover (3/1/2015)

But in my experience , import and export wizard is as fast as bcp. Like I said, I've copied billion records this way and tested with bcp and it was as fast as bcp.

That's never been my experience but that's not to say it didn't happen. Different environments work different ways. How long did that bad boy take to complete and how wide were the rows?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)