This project is read-only.
sqlserverdump version 0.0.1
By Daniel Jann, inspired by the mysqldump utility by Igor Romanenko, Monty, Jani & Sinisa.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license.

Dumping structure and contents of SQL Server databases and objects.
Usage: sqlserverdump [OPTIONS] database [OBJECT1 [OBJECT2 [...]]]
OR sqlserverdump [OPTIONS] --databases [OPTIONS] DB1 [DB2 [DB3 [...]]]
OR sqlserverdump [OPTIONS] --all-databases [OPTIONS]

The following options may be given:

--all-databases
Dump all the databases. This will be same as --databases
with all databases selected.

--databases
Dump several databases. Note the difference in usage; in
this case no objects names are given. All name arguments are
regarded as database names. 'USE db_name;' will be
included in the output.

--result-file=name
Direct output to a given file. If omitted, result will be
directed to standard output.

--server-name=instancename
Connect to the local instance instancename. If this option is
omitted, it will try to connect to the local instance. If there is
more than one local instance, an error message will be output.
It is recommended to always use this option (with this syntax
or the one below) as detecting the local instance doesn't always
work.

--server-name=host\instancename
Connect to the instance instancename on host. If this option is
omitted, it will try to connect to the local instance. If there is
more than one local instance, an error message will be output.
It is recommended to always use this option (with this syntax
or the one above) as detecting the local instance doesn't always
work.

--system-databases
Include system databases. Not included by default.

--system-objects
Include system objects (except for sysdiagrams table
which is always included). Not included by default.

Last edited Sep 22, 2011 at 7:58 AM by helvartis, version 4

Comments

No comments yet.