At 12:49 PM 2/5/2003, you wrote: >Let me narrow the focus a bit. Specifically I have a zipcode database that I >need to use in various DBs. Is there a "best way" to keep this data current >across all instances? Should I replicate it when I install the new one?
For something as common as a zip code database I think copying/replicating it into every db you need it in would be more hassle than it's worth. Perhaps I missed it in your earlier post, but if you're using SQL Server (and I'm sure other DB servers can do the same), why not simply reference the foreign db/table in your queries? For example, say you have db/table WebApp/customers and db/table Utility/zipcodes - in your CFQUERY, use the DSN for WebApp and then reference the zip code table as Utility.dbo.zipcodes. Jay ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
