Problem solve Get help with specific problems with your technologies, process and projects.

Export multiple tables within SQL Server

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?
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 last published in June 2005

Dig Deeper on SQL Server Database Modeling and Design

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.