On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
   
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

Quick Bid - 15.05.03 Database Maintenance - Synchronizing Databases - QB

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

Synchronizing databases copies information contained in the Master Menu tables of one database and inserts that information into another database.

Note

Notes on Synchronizing Databases

  • When synchronizing databases, no information is removed from the Source database. It is only being added to the Destination database.
  • Information that already exists in the Destination database will be updated to reflect what the Source database contains. (See note below for an exception)
  • Synchronizing databases does not copy or transfer any Bids; only the Master Tables are affected. To transfer Bids from one database to another, follow the instructions in your product's User Guide for Copying and Pasting Bids.
  • Synchronizing databases does not copy over the New Bid, M/U Cost Codes, or Lookup settings configured under Tools > Options. These must be configured manually for every database.
  • Synchronizing database does copy over the General, Category Codes, and Folders settings configured under Tools > Options.
  • For Quick Bid, synchronizing database does copy over the settings configured under Tools > Payroll Settings and Tools > Default Markups and Indirect Expenses.
  • When synchronizing databases, all Master Tables or a combination of Tables can be synchronized (by default, all Master Tables are copied to the new database). You can adjust this before synchronizing.

How to Synchronize Databases

Click Tools > Synchronize Databases - the Synchronize Databases dialog opens

Quick Bid Synchronize Databases dialog box - default view

By default, the option to Synchronize all Master menu tables is selected. If you want to synchronize only certain tables, uncheck the box next to Synchronize all Master menu tables and select only specific tables to synchronize. Some tables are dependent on other tables - for example, Styles is dependent on Condition Types and Layers so those tables would automatically be selected if you check Styles.

Quick Bid Synchronize Databases dialog box - expanded view to choose specific tables to synchronize

Click Start

When synchronization is complete the new database will include the selected Master information.

Note

Some companies keep a Master (template) Database and synchronize to this when creating new databases for each project, month, quarter, etc. - however they've chosen to organize their databases. This can save a great deal of time when setting up new databases and ensures every database contains the same settings and Master information.

For Contacts, let's say you enter "Michael Smith Company" as a Contact in your Source database and synchronize it with a Destination database. A Contact "Michael Smith Company" is created, as expected, in the Destination. Now, let's say you edit that Contact in your Source database, maybe the company's name changed to "MSmith Co.". When you synchronize your Source into your Destination database again, Quick Bid does not update the existing "Michael Smith Company" record, it creates a new Contact named "MSmith Co" and leaves the existing Contact untouched. This is done to preserve historical data/states of existing bids. If you want you users to have a fresh set of Contact, based off your Source, they should create new databases and then synchronize those to your Source database.

click here to view the previous article Database Maintenance - Compact and Repair Database Maintenance - Backup & Restore click here to view the next article



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! The information in this site is protected by copyright by ConstructConnect. You may not reproduce, adapt, or publish any content from this site in whole or in part for any purpose, without the express written consent of ConstructConnect, Inc.
Copyright 2024 - All Rights Reserved.