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
Example
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 |
|---|
--host
| string, required | host of instance to show |
--instance
| string | name of instance to show |
--port
| string | port of instance to show |
Example
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 |
|---|
--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' |
Example
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 |
|---|
--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 |
Example
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 |
|---|
--host
| string, required | host of instance to unlink |
--instance
| string | name of instance to unlink |
--port
| string | port of instance to unlink |
Example
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
Comments