Combine identical databases!
Have you been running with separate databases in each office? Are you ready for the benefits of a central data store? If so, JMJ Group Consulting can merge your databases into one master database. Combine this with a web application and you can realize the benefits of a primary central data store.
Usually the databases to combine all share the same database structure or schema - same tables and columns but different data. There can be many challenges with combining two databases. The benefits outweigh those challenges.
Effectively designed databases use primary and foreign keys to uniquely identify information in the database. It is common to use a generated key, e.g. counter, auto number, sequence, identity or custom technique. For example, in a database that lists people you might have an identifier of 1000 for Joe. In another database the identifier 1000 might be for Sally. You cannot bring Sally into the other database as you cannot have one identifier for two different people.
Have you ever wanted to combine or merge two databases? Thought it was impossible because of overlapping row identifier problem? Using JMJ Group Consulting’s DB Merge utility we can combine two identical databases. We have solved the primary/foreign key conflict problem. Our DB Merge utility handles the necessary transformations. This ensures the new database has the correct data relationships.
For more information on combining databases, please Contact Us.