Tag Archives: multi-database

Using Multiple Databases with CyberMatrix Software

Databases

Databases

Occasionally we are asked how our software can use multiple databases. Some people need to keep track of different sets of data and want two databases to ensure this data remains separate. There are two ways to do this: by switching the data path or with multiple installs.

Switching the Data Path

All our database software with the exception of all client/server editions, all enterprise editions, all web editions and Project Clock Standard, has an option to change the data path setting. This setting tells the software where the database files are located. To use multiple databases then all you need to do is have a separate data folder for each database. Then when you want to access the data from another database simply change the data path setting to this other database.

This solution is the simplest but requires the cumbersome process of changing the data path each time. You can minimize this inconvenience by putting all database in the same folder with similar names. e.g. Data1, Data2, Data3. This way all you have to change is the number.

For all enterprise editions you can do something similar by having several different databases with similar names e.g. pc1, pc2, pc3. If you use the same login ID and password for each database you can just change the database name in the Options Screen to switch to another database.

Multiple Installs

All of our software products, with the exception of all enterprise editions, have been designed to allow the use of a database folder residing within the program folder. For example, if your software is installed in C:\Apps\Project Clock\, it will first look for a data folder called C:\Apps\Project Clock\Data. If that folder exists and contains data files, it will use this folder. We added this feature for testing purposes but you can make use of it to use the software with multiple databases.

Using this technique to work with multiple databases is very simple. Suppose you want two databases in the following folders: C:\Apps\PC1\Data and C:\Apps\PC2\Data. First, you would run the setup program twice, choosing the Data Only install to create each of your database folders. Next, run the setup program twice again to create the two program folders, one in C:\Apps\PC1 and one in C:\Apps\PC2.

If you’re comfortable working directly with files You could just copy and paste the files and folders directly.

That’s all there is to it to create multiple databases for your software.