DUPLICATE CONNECTION

Core command DUP CO DUPCO

Creates a database connection from a copy of an existing one, through the connection wizard.

Syntax

DUPLICATE CONNECTION <source> <new_id>

Arguments

Argument	Required	Values	Default
`<source>`	Yes	The ID of an active connection to copy	None
`<new_id>`	Yes	The ID of the new connection, at most 15 characters	None

Examples

DUPLICATE CONNECTION MYDB01 MYDB02;

Details

The two IDs

The source must be an active connection; an inactive one is reported as such.
The new ID follows the rules of ADD CONNECTION: at most 15 characters, case-insensitive, refused when an active connection uses it. When an inactive connection uses it, the command offers to reactivate that connection instead, and nothing is duplicated.

The wizard

Every field (Name, Type, URL, User Name, User Password, Database Group, Environment, Comment) starts with the value of the source connection, then the wizard of ADD CONNECTION runs, so that you can keep or change each value. It ends with Save database connection [y/n/c]?: y saves, n starts again, any other answer stops without saving. Since two connections cannot share a Database Group and an Environment, change one of them, or clear the Database Group, for a connection of the same group.

ADD CONNECTION, the fields of the wizard
EDIT CONNECTION
Connections

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.