ferdyh Asked: 2011-05-11 00:32:48 +0800 CST2011-05-11 00:32:48 +0800 CST 2011-05-11 00:32:48 +0800 CST Microsoft SQL alternative for Oracle's Imp and Exp command 772 I'm looking a command line tool or SQL command to export/import a table or complete database. Much like the imp and exp commands of Oracle databases. Any suggestions? sql-server database oracle export import 1 Answers Voted DCookie 2011-05-11T06:55:27+08:002011-05-11T06:55:27+08:00 Have a look at the bcp utility (bulk copy). It only does a table at a time, but here is a script that will do the entire thing. As for a single command to export an entire database, it appears from this StackOverflow question that it is not possible.
Have a look at the bcp utility (bulk copy).
It only does a table at a time, but here is a script that will do the entire thing.
As for a single command to export an entire database, it appears from this StackOverflow question that it is not possible.