Copying Database Connections

Owned by Stonebranch
Jul 05, 2023
2 min read

Overview

You can make copies of all Universal Controller records, including Database Connections, using the standard method for Copying a Record: selecting Insert on the Action menu.

However, you also can use the Copy action on the Database Connections Action menu or the Copy button in the Database Connections Details.

Copying One or More Database Connections from a Database Connections List

Step 1

From the Agents & Connections navigation pane, select System > Database Connections to display the Database Connections list.

Step 2

Locate the Database Connections(s) you want to copy (see Filtering).

Step 3

Copy the Database Connection(s):
 
Copy One Database Connection

  1. Right-click the Database Connection Name.
  2. On the Action menu, select Copy. A Copy Database Connection pop-up dialog displays.

3. Enter a new name for the Database Connection and, optionally, select any Business Services that you want the Database Connection assigned to.
4. Click Submit to create a copy of the Database Connection.

 
Copy Multiple Database Connections

  1. Ctrl-Click the Database Connections you want to copy.
  2. Right-click any of the selected Database Connections.
  3. On the Action menu, select Copy.
  4. On the Confirmation pop-up that displays, click OK. The copied Database Connections are added to the list, with -Copy added as a suffix to the Database Connection Name for each Database Connection. If a Database Connection with that - Copy name already exists, another copy is not created.

Copying a Database Connection from the Database Connection Details

Step 1

Select a Database Connection from the Database Connections list. The Database Connection Details for that Database Connection displays.

Step 2

Either:


  • Click the Copy button.


  • Right-click the Details to display the Action menu, and then click Copy.

A Copy Database Connection pop-up dialog displays.
 

Step 3

Enter a new name for the Database Connection and, optionally, select any Business Services that you want the Database Connection assigned to.

Step 4

Click Submit to create a copy of the Database Connection.

Copy Permissions

To copy a Database Connection, you must have both Read permission and Copy command permission for the Database Connection you are copying, in addition to having Create permission for the copied Database Connection.