How To Insert 3,000,000 Records into a SQL Server Database

[szlamany]

tg is correct in that it's a not-logged insert - which is why it's fast.

It also does bypass "referential integrity" to some degree - but I would imagine that some of that can be controlled.

[techgnome]

tg is correct in that it's a not-logged insert - which is why it's fast.

It also does bypass "referential integrity" to some degree - but I would imagine that some of that can be controlled.

Does that also mean that it will bypass triggers as well? We don't use triggers here (on penalty of death by paper cuts) so I'm not too clear on what would happen in that case.

Tg

[szlamany]

Does that also mean that it will bypass triggers as well? We don't use triggers here (on penalty of death by paper cuts) so I'm not too clear on what would happen in that case.

Tg

Tg - I'm not sure - as we also dislike triggers... (yuk, bury business rules in hard to find places when you have STORED PROCEDURES where it really belongs)

BTW - as far as reformatting data - we prefer to do it in VB, where we have complete control - then utilize the DATABASE ENGINE for as little as is required - BULK INSERT alone...