Delete A Database

This document outlines the steps for removing databases in the CV11 system. This process involves using the administration tool which is very low level, so please back up your entire CV11 folder first and then be cautious while proceeding.

This procedure should not be used to delete the default databases that ship with Collect! but it may be used to properly delete and deregister a database that you have created.

1. Have all users sign out of CV11 and shut down your RDS server.

2. Make a backup of your entire CV11 folder.

3. Start your RDS server.

4. Navigate to your CV11\bin folder and run the admin.exe.

5. Double-click on RDS listed in "Servers" and log in with admin as the username and secret as the password.

At this point, a little bit of investigation and understanding is necessary. Each database in Collect! is in a registered device. In the default install, your Masterdb, Demodb, and Prosdb each have a few databases within them. The prefix on the database name indicates which one it's for. The suffix indicates what information is in it. To remove an entire set (for example, newdb) you need to identify which one it is.

a00_collect - The Archive database for Masterdb. This is where clients, debtors, contacts, transactions, and note are stored when archived.

d00_collect - The Main database for Masterdb. This is the bulk of your information - your clients, debtors, transactions, contacts and notes.

d00_impex - The Import database for Masterdb. This is where your import maps are stored.

d00_nxuser - The User database for Masterdb. Users, User Levels, and Access rights.

d00_report - The Report database for Masterdb. All of your reports and letters.

d00_rates - The Rate Plan database for Masterdb. Commission rate plans.

d00_trlog - The Transaction log for Masterdb. If you have "Change History Logging" enabled, this DB stores your history.

w00_impex - The Web Host Imports for Masterdb. When records are created or modified via Web Host, these are used.

w00_report - The Web Host Reports for Masterdb. These are the reports that generate web pages for the Web Host.

The a01, d01, and w01 databases are for Demodb. The a02, d02, and w02 databases are for Prosdb. The dbimp_t and syscat databases are core system databases and should not be modified. Any x00, x01, or greater are external import libraries which should also be left at this point.

In our sample setup, we created a "newdb" database. This created all of the databases described in the list above, but with a 03 prefix. This includes a03_collect, d03_collect, d03_impex, d03_nxuser, d03_report, d03_rates, d03_trlog, w03_impex, w03_report. These would be the databases I would want to delete, if I wanted to remove the "newdb" database.

Before deleting these, I would double check that I have the right set by double-clicking the "d03_collect" database from the list in the admin tool. It will then bring up a "Modify Database" window and the "Device" would be newmaster, since that is the database I created.

Once I am confident that I have the right set of databases and that I have my entire CV11 folder backed up, I would select each of the a03, d03, t03, and w03 databases and delete them using the delete button in the admin tool.

Next, we need to remove the registered devices that these databases were stored in. In the admin tool, select View - Devices. In my list of devices, along with all of the stock devices, I have four which begin with newdb. They are newdb, newdb_a, newdb_l, and newdb_w. I select each of these "newdb" devices and delete them.

At this point, the work within the database engine is complete. All that needs to be done is to move the "newdb" folder out of CV11. Then the RDS can be restarted and when CV11 is restarted, the "newdb" is gone from the list.

Please be cautious proceeding with these instructions. And again, be sure you've backed up first.

See Also

- Database Topics