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?
|
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? | |||
|
feedback
|
|
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. | ||||
|
feedback
|