Table of Contents

Quick Bid - 15.05.01 Database Maintenance - Upgrading Databases after installing a new version of Quick Bid - QB

Views: 679 Last Updated: 09/17/2024 01:54 pm	0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

There are four maintenance options available for Access databases and three for SQL (the programs cannot backup SQL databases).

Upgrading Databases (Access/SQL), described below. You upgrade a database the first time it is opened in a newer version of Quick (typically after upgrading the product).
Compacting/Repairing Databases (routine/regular maintenance - required) (Access/SQL), described in the articles that follow. You use this utility to correct problems in your database and to reduce its size. The Repair function works on both Access and SQL databases, but the Compact function only works on Access databases. Your SQL Admin uses a function, built into SQL, called "Shrink" to reduce the size of the SQL Logs periodically.
Synchronizing Databases (Access/SQL), described in the articles that follow. You use this utility to copy Master information (such as Items, Assemblies, Estimators, etc.) from one database to another. Useful when creating a new database and you want to copy Master information but not Bid information to your new database from one or more existing databases.
Backing Up Databases (Access only), described in the articles that follow. You use this utility, to make a backup copy of your working Access database. Restoring is simply a matter of copying one or more backup copies to your working database directory.

Upgrading Databases

When you install a new version of Quick Bid, usually you will be required to upgrade any open databases to make them compatible with the new software. Upgrading a database usually involves adding new tables, fields, or other information to the database. This changes the structure of the database so that it is compatible only with the new version of the software. You are prompted to update each databases open when you first launch the product after installing the upgrade. Once a database is upgraded to the new version it cannot be accessed by previous versions of the software.

Caution

Verify your Activation Code supports the version of the software you intend to install before upgrading any databases (see Checking Which Version a License Supports (check before installing any upgrades!). If you are unsure whether or not you are licensed for an upgrade, contact Support before you install anything or upgrade any databases - once upgraded, a database cannot be 'downgraded' to support older versions.

See Related Articles for more information and advice about upgrading your software.

On Center Software recommends making an "Archive" copy of all databases (meaning, copying your "OCS Documents" folder to a safe place such as a USB or thumb drive) before upgrading any databases. Please contact your network administrator or IT person for assistance with safeguarding your databases before installing any program updates.

Warning

If your company uses SQL databases, all users must coordinate before installing an Upgrade. Only a 'dbo' can properly upgrade an SQL database and once upgraded, the database will be inaccessible to anyone who hasn't upgraded. If an unauthorized user attempts to open an interactive bid, he or she can cause the Bids to become disconnected. The SQL Administrator must ensure a full backup of the database is performed before upgrading - On Center's products cannot backup SQL databases before attempting to upgrade them.

Creating a Microsoft SQL Database

Database Maintenance - Compact and Repair