Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
Does the above impact Microsoft AX2009?
Is your AX already installed? Maybe you can get problems with Reporting and Analysis Services.
Dont forget to mark this as answer!
Francisco Silva | | 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.
Also u can follow this article
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics