Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index



Synchronization - Example

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Synchronization - Example

Intro

Suppose you have created a database for contacts registration and installed it on your partners' computers. Let's call the partners' database partner.bbd and yours - main.bbd

Part 1. Updating \ Adding Forms, Reports, etc.

Let's imagine that after some period of time the created database does not meet your partner's needs anymore, so they have asked to add several additional fields to it (for example, the web-page and photo fields). You have added the mentioned fields to your database, checked its functionality and now you need to update your partners' databases, preserving the information they have already entered into the database. In other words, you have your database (main.bbd) with updated forms and partners' database (partner.bbd) with an old contact form.

Updating procedure will be as following:

  1. Run the software.
  2. Open the database you need to correct forms at - partner.bbd.
  3. In the menu select File > Import/Export > Synchronize with another DB.
  4. In the displayed window choose the database with the updated forms - main.bbd
  5. A window will pop up, offering you to create a backup copy. Click OK and create a backup in case of synchronization errors.
  6. After that, synchronization buttons will be available:

  7. You need to update the form. To do that, click the Forms... button and choose the form you need to update. The software will warn you that the form already exists in the database, and will offer to either update it or import the form as a new one. Choose the Update option:

  8. The software will give you a warning with the list of fields to be updated, added or deleted:

  9. Click Yes.
  10. The form is updated. If you need to update or import other database elements that store no data (i.e., are not records), use corresponding buttons (Timers, Custom Export, etc.) and repeat steps 6-9. If you need to update all reports and queries, click the Other... button and choose an appropriate menu item.
  11. Click the Finish button to get back to work with the database.

If there are a number of partners (database users) or a lot of database elements that need to be synchronized, it is advisable to create a file for automatic updating. By means of such file the user will be able to update the database quickly and easily with just one click, not resorting to the synchronization dialog. Learn more...

Part 2. Adding Records from Another Database

You have decided to look through all the contacts your partners created in their databases, as well as through your own records. For your own convenience, you will have to combine all databases into one. The easiest way to do it is to import the information from partners' databases (partner.bbd) into yours (main.bbd):

  1. Run the software.
  2. Open the database you wish to add records to: main.bbd.
  3. In the menu select File > Import/Export > Synchronize with another DB.
  4. In the displayed window choose the database with imported records - partner.bbd.
  5. A window will pop up, offering you to create a backup copy. Click OK and create a backup in case of synchronization errors.
  6. After that, synchronization buttons will be available:

  7. You need to import the records. To do that, click the Records... button and choose the folder, records from which you wish to import. If the entry form in the opened database is different from the imported database, the software will not be able to import the records and you will see the following message:


    To bring the forms to identical state, please use the instruction described in Part 1.
  8. If everything is all right, in the folder tree you shall see a new folder that will store all imported records:

  9. If the records you need to import are stored in different folders, repeat steps 7-8 for every folder you wish to import those records from.
  10. If the records you are importing are connected with each other by relational fields, all the bonds will be restored once you are done with importing and click the Finish button. Note: in order to keep relational bonds, you will have to import all the connected records at once. If you click the Finish button during the process of adding the bounded records and then reopen the same database to continue importing the records, the bonds will not be saved.
  11. Click the Finish button to get back to work with the database.



All topics in the "Synchronization" section: