7.06.00 synchronizing databases

Synchronizing databases copies information contained in the Master Menu tables of one database and inserts that information into another database.  By default, all master tables will be copied to new database but this can be customized on the Synchronize Databases dialog box.

Notes on Synchronizing Databases

• When synchronizing databases, no information is actually removed from the Source database. It is only being added to the Destination database.

• Synchronizing databases does not copy or transfer any BID information, only the Master Tables are affected.  To transfer Bids from one database to another, see Copying Bids (synchronize first, then copy Bids).

• Synchronizing databases does not copy over the New Bid, M/U Cost Codes, and Lookup settings configured under Tools>Options.

• Synchronizing database DOES copy over the General, Category Codes, and Folders settings configured under Tools>Options.

• Synchronizing database DOES copy over the everything from the destination database configured under Tools > Payroll Settings and Tools > Default Markups & 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).

How to Synchronize Databases

• Click Tools > Synchronize Databases - the Synchronize Databases dialog opens

Synchronize all Master menu tables (default), or 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 Styles is selected.

• Click Start
• When synchronization is complete the new database contains all of the master information (except employee login information)

• Some companies keep a Master (template) Database and use this to create new databases, saving a great deal of time.

Backing Up a Microsoft Access Database