Venable, John wrote: > Over time I have created many little web apps that parts of our organization > use. Inevitably there's time when I also want to utilize that data in the DB > to pull it to the website, often times relating it to another table that may > be in another DB. I know there are a variety of different reasons not to put > everything in one big database, but how does one relate disparate > Datasources? What are the various strategies for this, I can think of some > (i.e. DTS duplicating tables) but I wanna know what the big guys are doing.
I go for the Big Database, but use different schemas. As long as you use sufficient different database logins, I don't really see the problem with security. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
