Merging Multiple Databases

[markphsd]

I'm going to be merging multiple databases into a central one.

I know that during importing to a merged database, a GUID ID can be added. However, this will only be helpful for the database, not the GUI application I'm using. Is there anyway to make the Standard Primary Key ID's unique as well? And be updated in the relational data?

Obviously an Order Table with have an OrderID and the OrderDetails Table with have an OrderID. But having a GUID will not relate these two tables. Performing a query joining both tables would end in a kind of cartesian result, because there would be many of the Same ORDERID's in the Orders Tabl.

I hope there's a standard response to this. It seems like by now there would be. I just haven't found one yet.

Thanks

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[markphsd]

I would have to say, never mind this for now. I have a solution.

Fortunately i have a SiteID witch would be the ID of each database. I will append this to the PKID's when importing into the main database. I believe this will cover it.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.