My background is in Oracle and I'm learning SQL Server. What is the fastest way to export multiple tables within SQL Server? If you use DTS through Enterprise manager, it appears to only do one table at a time. If it must be scripted, can you provide an example?

    Requires Free Membership to View

I have an Oracle background too and spent about five years working with Oracle full-time. If you're familiar with SQL Loader, you might want to give BCP a try. BCP is an independent command-line executable that pumps data out of or into a SQL Server database. So if you want to run multiple table exports simultaneously, just kick off a couple BCP scripts to run in parallel. For examples, look at the multitude of topics discussing BCP in the SQL Server Books Online.


Do you have comments on this Ask the Expert Q&A? Let us know.

This was first published in June 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: