We have migrated from BO XIr2 to XIR3 and I am cleaning up the old CMS and Audit tables from my SQL Server 2005 database.
I noticed that the XIr3 tables are much larger than the XIr2 tables. 4 mb v 170 mb. I also have 2 sets of tables in the XIr3 schema. I have 2 Aliases, IdNumber, Infoobject and Relations. I only have one for Lock. For example I have cms_infoobject5 and a cms_infoobject6.
I do not believe I should have 2 sets of tables. Also is there a why to reclaim space?
Any thoughts on this?
Thanks
Pat