Any chance you could get away with just one database which both sites access? It seems that most of the complication comes from having 2 DBs! I suppose this would only be an option if there were a lot of shared data between the two...
Which DBMS are you using? some have special tools for syncing DBs - but it's always going to be rather complicated! |