Here's an interesting article on the problems found with a production house who switched from Final Cut Pro to AVID.

http://magazine.creativecow.net/article/a-cautionary-tale-for-the-fcp-switcher

Quote:

"To their credit, Avid listened to everything we had to say and tried to help. In fact, they did help a lot addressing some issues along the way. Sending Bob Russo down here spur of the moment was above and beyond what I would have ever expected, given how small of a shop we are. I had multiple conversations with product managers, engineers, and others at Avid. They really were all trying their best to help us through the situation and get us back on track.

But the software itself was throwing up roadblock after roadblock, mainly because of the way the database works. It was doing what it was designed to do, make sure that all of the media was tightly controlled so that the editor can always find the original clips. And as such, it had a very rigid way of working which conflicts with the "new, more open Avid."