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?

link|improve this question
feedback

1 Answer

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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.