Re: RI - pros and cons

A major drawback of using RI is that it tends to make your application database vendor specific. If you intend building apps that will be used by different brands of databases I'd say putting the RI in your app is a good thing.

Another reason for not using RI is that RI is designed to stop people who aren't experts from doing stupid things. Quite often there are very good reasons for circumventing RI in the application (particularly during data conversion projects or providing data importing facilities). For conversions I guess you could just drop the constraints, do the conversion and then put them back on. For importing it may not be that easy.

If none of these issues apply to your environment then I think your DBA just doesn't like work.... Received on Thu Mar 21 2002 - 18:45:26 CST