Re: Agregating multiple databases

2008-11-29 Thread Johnathan Henderson
The DBs are identical, but on different servers. I'm not an expert at MySQL (the db we're using) so I'm not sure if it has the capability of doing cross server queries. -John On Nov 26, 12:29 pm, Rafael Bandeira aka rafaelbandeira3 <[EMAIL PROTECTED]> wrote: > For sure that's a way to do that.

Re: Agregating multiple databases

2008-11-26 Thread Rafael Bandeira aka rafaelbandeira3
For sure that's a way to do that. > > Can I create a model that will show me a list of all users in Ohio and > Kentucky? > Are both dbs on same host and can they be accessed by same app's db client and therefore be used in a same sql query? --~--~-~--~~~---~--~~

Agregating multiple databases

2008-11-26 Thread Johnathan Henderson
If I have more than one database with identical tables, is there a way for CakePHP to combine them? Example: DB1 has information for Ohio DB2 has information for Kentucky Both databases have a table that contains a list of Users (let's assume that the primary key was setup so that there wouldn'