MikeSydney
Posts: 1
|
| Posted: 11/05/2010, 2:01 AM |
|
Hi,
I do web development and for one of our client we did a section where members of the Judicial Conference of Australia can log in: http://www.jca.asn.au/members_section/ . It was done using a MySQL database (email address and password) and PHP.
The Judicial Conference of Australia has a second, more comprehensive database where they administer all user data. This is on their accountant's server and is done with CodeCharge. Now when new members join, existing members leave or change their email address, this information has to be altered in two databases (MySQL on one server and CodeCharge on another server). Is it possible that the MySQL database connects to the remote server where the CodeCharge database is stored and reads data from the CodeCharge database?
Thanks,
Michael
|
 |
 |
datadoit
|
| Posted: 11/05/2010, 4:55 AM |
|
CCS supports an unlimited number of connection objects, as Andy pointed
out. Your issue isn't going to be CCS, but rather the security between
the two systems. You'll want to secure that second connection in some
way, via a VPN, SSH, SSL, or otherwise.
|
|
|
|
andy
Posts: 183
|
| Posted: 11/05/2010, 5:37 AM |
|
CodeCharge does support multiple connections but you will doubtless need to do some custom operations to update a second set of tables via another connection.
e.g. In the AfterUpdate event, you can open your second connection, grab your values and update your specified tables.
_________________
Andy
RAD tools for rich UI controls:
http://www.koolphptools.com |
|
|
|
tallmik
Posts: 23
|
| Posted: 01/13/2011, 9:06 AM |
|
A bit of a late response...
What about setting up replication? MySql let syou replicate data at the row, or at the statement level, so any changes occuring on one server happen on the other(s).
If the two databases have different table layouts, you could carry a copy of the table(s) in the destination server, and use an insert trigger to deal with the difference in layouts.
Regards
Michael
|
|
|
|
|
