Hi.

We'd need to see your database structures to be of any help with that.


However, if you have two login systems already in use, where both are presumably using a users table with a unique AI ID integer for the users, merging them would be a problem. You would, at the very least, have to change the IDs of half the users, which might break other things. (I'm assuming both databases have tables that depend on either login table, which would have to be updated if you do this.)

Another option might be to create a third database, dedicated to the login system, where a table would hold an account for each user with a FK to each of the login tables from the other tables. That way each database could keep their user IDs intact, but you could still "merge" the users into a single "account". Then when they log in they would log into the "account", which would grant them access to both "users" from both databases.