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

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

Select Instance
Select the instance to show.

Instance:

( ) SQLDR1:1433 (SQLEXPRESS)
(•) SQLPROD1:1433 (SQLEXPRESS)

Host Name:           SQLPROD1
Port:                1433
Instance Name:       SQLEXPRESS
Authentication Type: WIN
User Name:
State:               Connected

add

dbvcli instance add [--OPTIONS]

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'

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

Instance Connection
Select the host where the instance is running.

Host:

( ) SQLDR1
(•) SQLPROD1

Instance Connection
Enter the port number of the instance.

Port:

> 1433

Instance Authentication
Select the type of authentication to use to connect to the instance.

Authentication Type:

( ) SQL Server
(•) Windows Authentication

Attempting to connect to instance on host 'SQLPROD1' using port 1433...
Note that connections are made by the agent running on host 'SQLPROD1', so any
IP addresses are relative to that host.
Successfully connected from host 'SQLPROD1' to 127.0.0.1:1433.

New SQL Server Instance
---------   ----   -------------
Host Name   Port   Instance Name
---------   ----   -------------
SQLPROD1    1433   SQLEXPRESS

Instance added successfully

edit

dbvcli instance edit [--OPTIONS]

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

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

Select Instance
Select the instance to edit.

Instance:

( ) SQLDR1:1433 (SQLEXPRESS)
(•) SQLPROD1:1433 (SQLEXPRESS)

Instance Connection
Enter the port number of the instance.

Port:

> 1433

Instance Authentication
Select the type of authentication to use to connect to the instance.

Authentication Type:

(•) SQL Server
( ) Windows Authentication

Instance Authentication
Enter the username for authentication to the instance.

Username:

> sa

Instance Authentication
Enter the password for authentication to the instance.

Password:

> *******


Attempting to connect to instance on host 'SQLPROD1' using port 1433...
Note that connections are made by the agent running on host 'SQLPROD1', so any
IP addresses are relative to that host.
Successfully connected from host 'SQLPROD1' to 127.0.0.1:1433.

Updated SQL Server Instance
---------   ----   -------------
Host Name   Port   Instance Name
---------   ----   -------------
SQLPROD1    1433   SQLEXPRESS

Instance updated successfully

unlink, rm

dbvcli instance unlink [--OPTIONS]
dbvcli instance rm [--OPTIONS]

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

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

Select Instance
Select the instance to unlink.

Instance:

( ) SQLDR1:1433 (SQLEXPRESS)
(•) SQLPROD1:1433 (SQLEXPRESS)


Unlinked SQL Server Instance
---------   ----   -------------
Host Name   Port   Instance Name
---------   ----   -------------
SQLPROD1    1433   SQLEXPRESS

Instance unlinked successfully