Misty, I think we need to know more about your Collections Management System to give you good advice. For example, is this a homegrown thing, or are you using some application that runs on top of Filemaker? Filemaker often handles both data storage and the front-end interface, where Oracle and MS-SQL are generally used with some other application running on top (i.e., MS-SQL and Oracle are the data storage part only).
And then if you could let us know more about the size of your database and what kind of material it contains, that would help us get started. Matt -----Original Message----- From: mcn-l-bounces at mcn.edu [mailto:mcn-l-bounces at mcn.edu] On Behalf Of [email protected] Sent: Thursday, March 11, 2010 1:36 PM To: mcn-l at mcn.edu Subject: [MCN-L] -Database Questions Hello All, I wanted to see if anyone has had any experience using Microsoft SQL or Oracle in a collections database manner. We currently use Filemaker Pro, which suits our purposes quite well. However, we are being encouraged by higher ups that we should convert to Microsoft SQL or Oracle. These seem a bit more advanced than we'd need. If anyone has any experience I would love to hear the pros and cons to such a conversion. Also, I'm interested in finding out any policies museums may have to access of image and video files. For instance, if you have a server dedicated to images and video footage, who can access? Would anyone within the museum (even outside collections) have access? Thanks so much for all your help. Misty Tilson _______________________________________________ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l The MCN-L archives can be found at: http://toronto.mediatrope.com/pipermail/mcn-l/
