Downgrade of SQL 2012 to SQL 2008 R2

This question is not answered

Does the above impact Microsoft AX2009?

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

     

     

    Dont forget to mark this as na answer!

    Francisco Silva Jr.

    Microsoft Dynamics AX

    http://fsilvajunior.blogspot.com.br

    This posting is provided "AS IS" with no warranties, and confers no rights.

  • 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.

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • 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.

    Mukesh Hirwani
    http://mukesh-ax.blogspot.in/ 

       

  • Also u can follow this article

    blog.sqlauthority.com/.../sql-server-restoring-2012-database-to-2008-or-2005-version-and-2-other-most-asked-questions

    Mukesh Hirwani
    http://mukesh-ax.blogspot.in/