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?
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.
Sign up to join this communityHave 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.