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.
(one quick example of what I am meaning is a zip code DB which I want to be able to relate to a bunch of other tables in various other DBs.) Thanks much, John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
