Re: looks like one database from the outside, but it's two inside

2007-07-20 Thread Clive Eisen
Sven Miller wrote: > And unfortunately I don't know enough about MySQL to be more helpful. > Database links may be an Oracle-only thing. > > On 7/19/07, Theron Stanford <[EMAIL PROTECTED]> wrote: >> This sounds like a good idea. I guess I just don't know enough about >> databases yet to know how

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Sven Miller
And unfortunately I don't know enough about MySQL to be more helpful. Database links may be an Oracle-only thing. On 7/19/07, Theron Stanford <[EMAIL PROTECTED]> wrote: This sounds like a good idea. I guess I just don't know enough about databases yet to know how to do this linking. Mostly I j

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Theron Stanford
This sounds like a good idea. I guess I just don't know enough about databases yet to know how to do this linking. Mostly I just know about how to get DBI to interact with MySQL. I should mention that I'd also like to be able to make some rules in the "real" database temporarily disappear while

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Sven Miller
I would consider setting up the test database to consist of a database link to the "real" database, along with views for all the tables. Then on those tables where I wanted to interject some data, I would create test-data tables and alter the views to merge the data. Then switching from "test" to

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Theron Stanford
Thanks to all, and apologies to all. I should have waited another day to flesh this out before sending, but I was trying to take advantage of living on the west coast of the USA to send this out last night and come to work this morning to find my inbox teeming with lots of interesting ideas. Dum

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Mike Nhan
ne database from the outside, but it's two inside Overview: I'm trying to create the situation in the subject line: from the outside, the database handle thinks it's just one database, but inside it's really two databases containing tables with the same schema but not necess

Re: looks like one database from the outside, but it's two inside

2007-07-19 Thread Tim Bunce
On Wed, Jul 18, 2007 at 10:23:52PM -0700, Theron Stanford wrote: > Overview: I'm trying to create the situation in the subject line: > from the outside, the database handle thinks it's just one database, > but inside it's really two databases containing tables with the same > schema but not necess

looks like one database from the outside, but it's two inside

2007-07-18 Thread Theron Stanford
Overview: I'm trying to create the situation in the subject line: from the outside, the database handle thinks it's just one database, but inside it's really two databases containing tables with the same schema but not necessarily the same data. Specifics: Where I work we have a web site with c