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
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain.
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline.
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.