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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Downgrade of SQL 2012 to SQL 2008 R2

(0) ShareShare
ReportReport
Posted on by 95

Does the above impact Microsoft AX2009?

*This post is locked for comments

I have the same question (0)
  • fsilva-jr Profile Picture
    20 on at

    Is your AX already installed? Maybe you can get problems with Reporting and Analysis Services.

  • Tommy Skaue Profile Picture
    Moderator on at

    I don't think you can downgrade major versions (like 2012 to 2008) of SQL Server in-place. You might be able to downgrade Editions (like Enterprise to Standard).

    As for AX2009, the only thing you need to make sure is that the database is accessible by the AOS service.

  • MukeshHirwani Profile Picture
    1,180 on at

    U can create SQL script to perform same. Right click on DB > Task > Generate Script > Run Wizard. This will generate a script. Run the same script to the SQL where u want to migrate to..

    Just make sure network is same, as data will have domain and SID info stored. Also, both old & new DB server should be able to talk to each other.

  • MukeshHirwani Profile Picture
    1,180 on at

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans