I'm converting our databases from Access to MS SQL7. The Upsizing Wizard has handled everything. My question is about consolidating databases. For example I built a CF interface that lets managers upload files and add page content. File locations and descriptions, and text for page content, is stored in Access databases. Each database has about four tables. It occurs to me I could simplify by having all Web-based administration in one SQL database. What I don't know is whether it would be best in the long run to consolidate by function, or perhaps by department. I suppose it's possible that some day Marketing would insist that it's data be separate from Accounting. Comments?
Keith Purtell, Web/Network Administrator VantageMed Operations (Kansas City) Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. --- [This E-mail scanned for viruses by Declude Virus] ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/[email protected] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
