469,935 Members | 1,604 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,935 developers. It's quick & easy.

How do you export?

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
Jul 23 '05 #1
1 1663
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
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by DarkSpy | last post: by
205 posts views Thread by Jeremy Siek | last post: by
6 posts views Thread by maricel | last post: by
5 posts views Thread by David | last post: by
1 post views Thread by chaitu | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.