imitchell - Tuesday, June 21, 2011 10:46 PM:
Hi Folks,
Is extending the Aras DB a common activity or do projects typically avoid that?
If the Aras DB is sometimes extended, what are the implications of doing this in terms of Aras updates.
(updates can include new tables, new fields in existing tables, stored procedures, etc.)
Thanks,
Ian
aponceot - Wednesday, June 22, 2011 4:04 AM:
Hi Ian,
According to me, it is not a good idea to extend the Aras Db. If you need additional tables, just create a new Item Type, it will do it for you in the database, if you need to create a new field, just add a property to the item type, Aras will add a column in the DB.
It may be ok to add stored procedures but in this case, I suggest you to have a look to the 'SQL' Item Type in the Administration category of the TOC.