Q
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.

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close