Microsoft SQL alternative for Oracle's Imp and Exp command

Question

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?

Answer 1

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.