On 8 Jan 2004, at 04:12, Paul F wrote:
Greetings, I am wandering under what circumstances it is sensible/beneficial
to use multiple databases for a single "project," and why.
The reason I ask is because I am re-developing an existing database with
MySQL that someone else created with another engine (DBISAM) and chose to
have 5 separate databases used by one application.
I've worked on a project where we had 2 databases; one was for "live" data, the other was used when the application switched to a training mode and so couldn't affect live data. It was a Windows app and connection was via ODBC. We had 2 ODBC sources set up to point to same server, but a different database. (Actually, it was a MS SQL Server, but the same principles apply). It was a simple matter of deciding which source to use depending on whether the app was in training mode or not.
I can't think of a reason for 5! :)
Steve.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
