On the Workbench server go to the \workbench\qwb_data folder and then open the folder that contains the database you want to make a copy of. Right-click the FDB file and choose [Copy].



Create a new folder under QWB_DATA that reflects the name of the database you are creating and paste the FDB file into it. Rename it to the same name as the folder.



Run the IBOConsole utility from the \workbench\fbserver\bin folder. It is recommended that you right-click the IBOConsole.exe and ‘Run as administrator’. Click [Yes] to the User Account Control (UAC) prompt.



If you have already used IBOConsole then the server will already be registered so you can skip the next step. To register the Workbench server, right –click on [Servers] in the left-hand window and choose [Register].



Enter a Description, then SYSDBA as the User Name and the sysdba password (default is masterkey), then click [OK].



The server will now be registered.



The next step is to register the database so expand [Local Server], right-click [Databases] and choose [Register].



Click the Browse button (…) and locate the fdb file, then click [Open].



Remove the .FDB from the Alias Name and then click [OK] (no need to enter Login Information). Now that the alias is registered, double-click it to connect.



At this point you need to run an SQL script to turn off the mail support for users. If this is not done, as soon as the alias is added to the Configuration Manager for Workbench, it will send out any outstanding mail and carry sending new mail which duplicates the database it was created from.
To run the script, right-click the alias name and then click the [SQL] icon on the menu bar.



Enter the following text into the SQL window at the top of the Interactive SQL window and then click the ‘Lightning’ icon on the menu bar (or press CTRL+E).

update STAFF
set MAILTYPE=48,
MAILPASSWD='',
MAILADDRESS='';

commit work;



The script will run and you should see no output but the folder icons become ‘live’ in the menu bar. You must click the folder with the checkmark to apply the script. Once applied the icons Grey out. You can now close the Interactive SQL and IBOConsole utilities.



Run the Workbench Configuration Manager (right-click, run as administrator) and go to the [Aliases] tab, then click [Add]. Enter an Alias Name then click [Browse]. Locate the database file and then click [Open].



If you require the Active Directory support for this new alias, click the alias name and then click the [Workbench] button. Check the [Use Windows NT Logon] checkbox, and depending on whether you want users to enter their domain password when logging in, check or uncheck the [Require Password] to login to database checkbox. Click the [OK] button.



Click [Apply] then click [OK] to the Information dialog, click [Yes] to the Confirmation dialog, click [Yes] to the Confirmation dialog for the [IVPro] Settings. Once the [OK] and [Apply] buttons are Greyed out you can close the Configuration Manager.
The database will now be available in the Workbench client.