What are the Databases will create when install Axapta 2012 with SSRS

Finance and Operations/AX Technical Forum
1

Hi,

I have Installed axapta 2012 R2 with SSRS reports.

After Installation, i could see there are 5 data bases created, those are

  1. MicroSoftDynamicsAxapta

  2. MicrosoftDynamicsAx_Model

  3. MicrosoftDynamicsAxBaseLine

  4. ReportServer

  5. ReportServerTempDB

In which database Object changes(like changes in the Table, Form, and class code ) and Table records will be stored.

I have browsed but i could not get the each database purpose.

Can any one please help me with this knowledge.

Thanks,

Satish

2

The AOS connects to the Microsoft Dynamics AX database to process transactions.

The AOS connects to the model store to display application elements such as forms and reports.

The baseline database contains a model store that is used to upgrade X++ code to Microsoft Dynamics AX 2012. The baseline database is used to analyze application updates before they are applied.

Reporting services database. You store your SSRS reports here.

Report server temporary database.

3

Thanks Kiran for your reply.

I got some eloberated explanation from the net:

Model store database
The model store is the database where all application elements for Microsoft Dynamics AX are stored. Customizations are also stored in the model store. The model store replaces the Application Object Data (AOD) files that were used in earlier versions of Microsoft Dynamics AX.

Baseline model store
The baseline model store holds model store tables for the earlier version of the metadata and is used only during upgrade. The baseline model store is like the old folder in earlier versions of Microsoft Dynamics AX.

Note : In Microsoft Dynamics AX 2012 R2, the model store was moved into a database that is separate from the business database.

Thanks.

Satish

4

Just to complement. ReportServer And ReportServerTempDB aren’t related directly to an AX installation, those db’s are created during the installation of reporting services.