web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 R3 Baseline DB
Microsoft Dynamics AX (Archived)

AX 2012 R3 Baseline DB

(0) ShareShare
ReportReport
Posted on by Evaldas 1,800

Hi all,

When AX 2012 DB for upgrade is installed it is possible to specify the name of the Baseline DB which is a replacement for Old folder. Now with R3 you get one more Baseline DB which is named <databasename>_UpgradeR3Baseline. So if you specify Baseline DB you get two databases: <databasename>_baseline and <databasename>_UpgradeR3Baseline. After upgrade it looks like that only new one was used. So i have tried to leave the Baseline DB field blank during installation. As a result I got only <databasename>_UpgradeR3Baseline created. Server configuration is now pointing to the automatically created Baseline DB regardless of whether you specified Baseline DB or not.

Does anybody know something about it? Should we leave the Baseline DB name blank from now on? If yes, why its still in the installation wizard?

 

Thanks in advance for any input!

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Evaldas,

    You can download the AX 2012 Upgrade guide. www.microsoft.com/.../details.aspx

    From page 40 it will tell you about the In place upgrade from AX 2012 or AX 2012 R2 to AX 2012 R3.

    The guide tells you to leave the Baseline DB blank. If you fill it, it will indeed create a baseline like the In place upgrade from AX 2012 to AX 2012 R2.

    The new Baseline method creates the old model store and replaces the standard layers with R3 models. So you will have a baseline with R3 and e.g. customizations in R2.

    This will be used for code merging.

    Have a look at this blog for a nice summary of this new mehtod: yetanotherdynamicsaxblog.blogspot.nl/.../upgrading-ax2012-r2-to-ax2012-r3.html

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Also have a look at this article: technet.microsoft.com/.../jj733502.aspx

  • Evaldas Profile Picture
    Evaldas 1,800 on at

    Hi Andre,

    I wasn't specific enough.

    For in-place upgrades before R3 one had to specify the same name (as data database) in order to have  baseline, in R3 it is created automatically. That's clear.

    Recently, I had upgraded from AX 2009 to AX 2012 R3. And for that case you have needed to specify baseline DB. But it looks like if you specify that now in R3 you get two baseline DBs.

    When the questions is, why it has not been removed from installation wizard?

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

    Hi Evaldas,

    You have to leave it blank when you are upgrading from another AX 2012 environment, but you can choose to create a new baseline database on a clean install of R3. So in fact it is still used.

  • Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at

    Are you saying if you run the upgrade for R3 it will create both the DBNAME_baseline AND the _UpgradeR3Baseline? I personally haven't tested that, but if that happens, it has to be a bug.

    Anyway. The baseline is the AX2012-equivalent for Old, as you've pointed out, and regardless of how many baseline databases setup creates, you can only define one baseline on the AOS Service Configuration. So you will have a baseline database you can compare new code with old code, if necessary. In order to successfully merge and upgrade the R2 code to R3, you need the R2 code available using the baseline-database.

    Regarding the installation guide and the steps explained there, always try to be critical to the steps outlined and try to assess if you believe they are correct or not. There might be errors in the guide that needs to be corrected in an addendum. The guide is pretty well made and covers A LOT of ground, but if you follow it verbatim, word for word, without knowing why, then you might get lucky - or not. Not saying you are, Evaldas. Just saying some IT pros do.  ;-)

  • Evaldas Profile Picture
    Evaldas 1,800 on at

    Hi Tommy,

    Yes, it creates two baseline DBs if you specify the baseline DB name during installation. And that caused me a confusion. I could not find a good reason for having two baselines.

    I completely agree with you for being critical about the guides. They have never been perfect :)

  • Evaldas Profile Picture
    Evaldas 1,800 on at

    Andre,

    Yes, that makes sense :) One can still want to have baseline in a clean installation to compare old vs. new customization.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans