Is it possible to move a r7.3.x or r8 Mart from one database version to a different database version upon upgrading to r9? For example, 7.3 Mart is on SQL Server 2005, but the r9 Mart will be on SQL Server 2012 or Oracle 12c.
Yes it is doable, since r9 Mart will be installed on its own database, as a new Mart. To upgrade the contents of the r7.3 or r8 Mart to the r9 Mart, you use the MartUpgrade Utility. The process for moving a r7.3 or r8 mart to a different database platform in r9, would be the same process for moving to a different version of the database platform. For steps on using the Upgrade Utility see the TechDoc:
‘How to upgrade your r7.x / r8 mart to r9 mart using the MartUpgrade Utility’,
For Mart r9 to r9 database move, you would need to checkout the models from one Mart database and then save the models manually in to the new Mart database. Versions will not be moved with these steps.