Q

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

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close