How do you export?

[Do Park via SQLMonster.com]

Hello all,

I don?t often export data from a table. I am wondering how you export data
from a table. I?d like to know how you export in real world.

Do you export data from a table to a flat file or what type? There are many
selections when you choose file type.

When do you need to export data? How often?
Do you use DTS rather than export wizard?
Do you use a script to export?

Best Regards,
Do

--
Message posted via http://www.sqlmonster.com

[Erland Sommarskog]

Do Park via SQLMonster.com (fo***@SQLMonster.com) writes:

I don?t often export data from a table. I am wondering how you export data
from a table. I?d like to know how you export in real world.

Do you export data from a table to a flat file or what type? There are
many selections when you choose file type.

When do you need to export data? How often?
Do you use DTS rather than export wizard?
Do you use a script to export?

Usually when you export data, there is some taker of the data. What format
you pick depends on the taker of the data. I think in our application,
data export is mainly through VB programs, because the file produced
comes from several sources, and there are special requirements on positions
etc.

If I'm just moving data from database to another, I use BCP, typically
with character format out of habit.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp