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 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 testing, but I fear this will make things even more complicated. On 7/19/07, Sven Miller <[EMAIL PROTECTED]> wrote: > 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 "real" is a matter of changing where you > connect to. Alternately, you could change the views to only > incorporate test-data if a certain flag is set in yet another test > table. >