Container Manager

Static Container Wizard

Before creating a Static Container, make sure that all the servers that contain the databases that you wish to assign to the Static Container are registered as Combine Servers in the Object Browser. When the Static Container wizard is started, the following welcome page will appear. If you do not want to see this welcome page every time you start the wizard then click the checkbox "Do not show welcome page next time" and press Next.

Figure 28:  The welcome page of the Static Container Wizard.

After you press the Next button, you must enter the name of the Container. Two containers in the same Environment should not have the same name in general, to avoid confusion. However, for code deployment purposes, Combine identifies the Container name through the name of the folder under which the Container resides (if any) together with the Container name, so that Containers can have the same name under different folders (this is not recommended).

The Container description is optional and allows you to put comments in the Container for your own reference.

The authentication type can be set to one of SQL Authentication, Windows Authentication, or Prompt which is also the default. When Use parent connection properties checkbox is checked all connection properties are inherited from a parent node. The parent node can be either a folder or an Environment. Also you are able to modify all SQL server connection options using Advanced button.

Note that when either Windows authentication or Prompt is selected, Combine will not store your user name and password anywhere.

Figure 29:  Entering the Container name, description, and authentication type.

After pressing Next, databases can be added to the Static Container by pressing the Add Databases button. You can also press Next to complete the Container creation and then add target databases to the Container at a later time.

Figure 30:  The list of databases in the Container. When creating a new Container the list is initially empty.

To demonstrate all the features available in the wizard please refer to the example of the Development Environment given in Figure 31, and assume that we wish to create the Web Databases Static Container. Furthermore, assume that all other Containers in the diagram were already created before, and that the DevSvr1 and DevSvr2 SQL servers were previously registered as Combine Servers in the Object Browser (please refer to the section Registering Combine Servers to learn more about server registration). In other words, assume that the Object Browser and the Container Manager already have the Combine Servers and Containers displayed in Figure 32.

Figure 31:  Containers and target databases in the Development SQL server Environment.

Figure 32:  The Container Manager and Object Browser for the Environment in Figure 31, when all Containers are Static and the Web Databases Container has not yet been created.

There are two convenient ways to add target databases to the Static Container: Adding databases from Combine Servers or Registered Servers of the Object Browser, or copying databases that were already defined in other Static Containers. The second option will be disabled if you have not yet defined any Static Containers. In this example we will add the Web1Dev and Web2Dev databases to the Web Databases Static Container twice, to demonstrate each technique.

Figure 33:  Choosing the method to add databases to the Static Container.

Adding databases from servers in the Object Browser. The first option of selecting the Static Container databases allows you to choose databases from either Combine Servers or Registered Servers in the Object Browser. To use this method, click the Select Databases option as shown in the last figure and press Next. A new wizard window shown in the next figure will appear, and it allows you to choose the Container databases. Here, the two Web databases are selected on the DevSvr1 and DevSvr2 servers.

Figure 34:  Selecting the databases to add to the Static Container.

A single database can only be defined in the Container once. If you are adding databases that already exist in the Container then you will be prompted with a warning message. After selecting the databases press the Next button. The next wizard window will then display the Container databases. If you wish to remove databases from the Container you may do so as shown in the figure below, by right-clicking the grid and choosing the Remove option.

Figure 35:  Viewing the databases in the Static Container.

When done adding databases, press Next to confirm the changes and create the Static Container.

Adding databases from other Static Containers. The second method of adding databases to the Static Container is by selecting databases that already belong to other Static Containers. In this example, the Static Container named All User Databases was previously created and holds all user databases on the two SQL servers. This Static Container will be used to add the two Web databases to the new Static Container. In order to copy databases from other Containers, after pressing the Add Databases button, select the option "Copy databases from another Static Container" in the wizard as displayed in the following figure.

Figure 36:  Adding target databases from other Static Containers.

After hitting the Next button, the window presented below will let you select the databases from other Static Containers. In this example, the two Web databases are selected.

Figure 37:  Selecting databases from another Static Container.

When done, press the next button. You will then be presented with the list of databases in the Container. Press the Next button in the window that lists all Container databases and then Finish to complete the Static Container creation wizard.

Note: Additional databases can be added or removed from the Static Container at a later time by either activating the Static Container Wizard again, or by using the right-click menu options in the Container Manager.

© 2001-2018 JNetDirect, Inc. All Rights Reserved.