Combine supportBack to main support page
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.
The welcome page of the Static Container Wizard.
After you press the Next button, you must enter the name of the Container. Two Container names 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 and credentials of the Container will be used as the authentication type and credentials to connect and deploy code on all the target databases in the Container. Available authentication types are SQL Authentication, Windows Authentication, Prompt, or Use Parent Settings, where the latter is the default and uses the settings provided for the Container parent in the Container Manager tree. The parent node can be either a folder or an Environment.
Also you can use check box Use Encryption to turn on SSL encryption for a connection to DB server.
Entering the Container name, description, and authentication
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.
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.
Containers and target databases in the Development SQL server
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
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.
Choosing the method to add databases to the Static
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.
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.
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.
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.
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.