Random Primary Keys

See Replication.

Random primary keys are unique key ranges used by each server on Replication (both One-Way Replication and Daisy Chain Replication). They are an older method and not recommended. The recommended method is to instead use auto-increment variables to avoid data collision. See Replication Auto Increment.

Turn on Random Primary Keys

Random Primary Keys cannot be enabled in newer versions of Open Dental. Users who had Random Primary Keys enabled in the past will still have settings display in the Replication Setup window.

Use Random Primary Keys: Once random primary keys are enabled, they can never be turned off. Ranges can be freely edited. All of primary keys in all tables will be longer.

Set Ranges: Once servers are added, click to automatically create ranges.

Test: Click to generate sample keys for testing.

Double-click a server to edit the following:

Range Start/End: The allowed range is extremely large. Open Dental uses 64 bit signed int types internally and in the database. The allowed range is from 1 to 9,223,372,036,854,775,807. This key range is so large that this solution can be scaled up without ever running out of keys, no matter how many clinics are connected. We recommend ranges of at least 100,000,000 numbers. If smaller ranges are used, replication may become slow or unresponsive as the number of available primary keys runs out. This range recommendation will result in keys that are a very manageable 9 digits long. Also, JavaScript and other programs have a max int size of 9,007,199,254,740,992 (1000 times smaller), so it makes sense to stay under this value for future flexibility with other software.