Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010

    Unanswered: Integration of different database tables

    Hi Forum ,

    I had two different sites , one for e commerce and another one like a discussion forums. up to now i maintaining both in different servers with different databases .
    Now i would like to integrate both with respect to users , i.e. i don't to want to disturb the existing sites in the respective servers , i just want to integrate the users list in the tables only . when a user register in one site no need to register in another one and the vice versa .
    At present the fields in the both user tables in the databases are different only few like first name , last name was equal ..
    how can i integrate the fields and users list , can i achieve this by maintaining in different databases.
    please share your ideas .

    thanking you in advance

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    Have you had a look at replication? You create a primary location for all the users. All new entries are added to this primary table and replicated to the other servers databases.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts