What is the approved procedure for creating several databases on one server?
We have been simply running the installer multiple times and changing nothing other than the database name. This seems to work. But, in one case, after creating a new data base, a previously existing database was disconnected from all of its files. The files were still on the drive, but the database was looking for them in an empty directory.
Hi Dave,
To install multiple databases, you need not run the installer as many times. While installation, in Configure Database page, once you define 'Database Login Options' and 'Database Options'. Click 'Configure Database' Button. After database configuration is done 2 install the second database, follow the steps:
1) Change 'Database Login Options' Section. (change username details (required) and password details (not-required))
2) in 'Database Options' section, Only change 'Database Name' option. And click 'Configure Database' button.
similarly u can configure as many databases u need by following the same method as defined above. When u click install in next page all the databases u configured will be installed. To verify whether the databases installed or not :
1) Goto installation folder and open InnovatorServerConfig.xml file. U will find multiple <DB-Connection tags for each database>
<DB-Connection id="InnovatorSolutions" database="InnovatorSolutions" server="(local)\SQLEXPRESS" uid="innovator" pwd="innovator_123" dbType="SQL Server" /> <DB-Connection id="MASTERDB" database="MASTERDB" server="(local)\SQLEXPRESS" uid="plural" pwd="plural_123" dbType="SQL Server" /> <DB-Connection id="InnovatorSolutions1" database="InnovatorSolutions1" server="(local)\SQLEXPRESS" uid="innovator1" pwd="innovator1_123" dbType="SQL Server" /> <DB-Connection id="USDB" database="USDB" server="(local)\SQLEXPRESS" uid="usschool" pwd="usschool_123" dbType="SQL Server" />
2) In aras login page, in Database field you will find multiple databases in the dropdown..
Cheers,
Naresh
Hi Naresh.
Thank you very much for this information.
I guess I should have specified that I'm not creating all of the databases at once. I want to be able to add databases to a running installation as needed.
The instructions for installing the demo database appear to create an additional database rather manually by editing Innovator config files and interfacing directly with the SQL Server Management Studio. I would be surprised if there isn't an automated way to do this.
BTW, my experience with running the install .msi process more than once is that there are some very unfortunate side-effects on the file/directory structure in the vault.
Thanks again.
Dave