By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,619 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,619 IT Pros & Developers. It's quick & easy.

How do you export?

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.