Manage Microsoft SQL Server instances

Subcommands

list, ls List linked instances
show Show details for an instance
add Add a linked instance
edit Edit linked instance
unlink, rm Unlink an instance

list, ls

dbvcli instance list
dbvcli instance ls

List linked instances

C:\Program Files\Dbvisit\standbymp\bin>dbvcli.exe instance list
Connecting to the Control Center at SQLDR1:4433 ✓

SQL Server Instances
---------   ----   -------------   ---------
Host Name   Port   Instance Name   State
---------   ----   -------------   ---------
SQLDR1      1433   SQLEXPRESS      Connected
SQLPROD1    1433   SQLEXPRESS      Connected

show

dbvcli instance show [--OPTIONS]

Show details for an instance

Option	Type	Description

Option	Type	Description
`--host`	string, required	host of instance to show
`--instance`	string	name of instance to show
`--port`	string	port of instance to show

add

Add a linked instance

Option	Type	Description

Option	Type	Description
`--host`	string, required	host running instance to add
`--password`	string	password for authentication to instance
`--port`	string	port number of instance to add
`--username`	string	user name for authentication to instance
`--auth-type`	auth, required	authentication type, value should be either 'SQL' or 'WIN'

edit

Edit linked instance

Option	Type	Description

Option	Type	Description
`--host`	string, required	host of instance to edit
`--instance`	string	name of instance to edit
`--port`	string	port of instance to edit
`--set-port`	string	new value for port
`--set-auth-type`	auth	new value for authentication type
`--set-username`	string	new value for username
`--set-password`	string	new value for password
`--ignore-errors`		apply edits even if connection to instance fails

unlink, rm

Unlink an instance

Option	Type	Description

Option	Type	Description
`--host`	string, required	host of instance to unlink
`--instance`	string	name of instance to unlink
`--port`	string	port of instance to unlink