I am using the term (rightly or wrongly) as SQL Server shows it. I have a single database Server with multiple "databases". I apologize if this is technically incorrect, I am obviously not a database "expert" but these are the terms I was taught and have seen quite often. If it helps, I think what I am referring to as a DB you are calling an instance.
john -----Original Message----- From: Lincoln Milner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 4:02 PM To: CF-Talk Subject: RE: DB Strategy I should like to put my 2� in here, since I've often heard the term "database" to be used inappropriately in conversation, even by those persons "working in the field." In Oracle, you have one Oracle database, typically. Within this database, you have one or more instances that live wholly on their own, and can only be accessed by one another via dblinks (the "db" starts the confusion). Within each instance, you have one or more schemas, logically structured to match what it is you're doing. Similarly, MySQL has "databases" that are created, they're not really databases. They could be likened to Oracle's concept of instances. They could be connected to one another without a whole lot of difficulty (if I am remembering correctly). I think the key here is that you should have one database (Oracle, SQL Server, MySQL, PostgreSQL, Informix, whatever). Within this database you can have instances of project data. This way, the data isn't commingled or lost in a shuffle of hundreds of tables, but theoretically can be accessed from one app to the next. To give you an example, we have in our offices one Oracle database. That database holds roughly 12+ instances that have little (most times nothing) to do with one another. Hope this helps... Lincoln ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
