AX2009 : Upgrade database AX3.0 to AX2009
Цитата:
I understand that upgrading application is a bit technical but upgrading data is something which a functional consultant also can do .. Follow the steps given below to upgrade an AX 3.0 version database to AX2009. SQL server 2005 is being used in the following steps. However the steps are same for SQL 2008 also
1. Take the backup of the data base for AX3.0
2. Restore the backed up database in SQL2005. Name it DBAX30_Upgrade or as per any convention you follow.
3. Backup the AX3.0 application . Name it “APPAX30_Upgrade”. Attach the database in step2 with the APPAX30_Upgrade application in an AX configuration. Name the configuration AX30_Upgrade
4. Open the environment AX30_Upgrade
5. Delete companies which are not required (OPTIONAL)
6. Synchronize the AX30_Upgrade
7. Run Left Justification (You have to import the XPO LeftJustified which comes with the AX2009 Setup for upgrade and run main job)
8. Run Column Upgrade(You have to import the XPO UpgradeColumnList which comes with the AX2009 Setup for upgrade main job)
9. Create a New Empty Database in SQL 2005 . Name it AXDB2009_LIVE . We are assuming that we are upgrading the database for Go-Live stage.
10. Run the upgrade tool (Supplied in the AX2009 setup disc) to prepare the data for upgrade from AX30_Upgrade into AXDB2009_LIVE.
11. At this stage we are assuming that application is already upgraded and tested. The upgraded application is e.g. “AX2009_Test”. and now we are doing the database upgrade for Gp-Live stage in the project. Copy the Application AX2009_Test into a new Folder AX2009_LIVE.
12. Create an AOS (thru AX setup). Name it AOS2009_LIVE.
Attach the Database AXDB2009_LIVE and application AX2009_LIVE with AOS2009_LIVE.
13. Start the application using configuration using the AOS “AOS2009_Live”. The application will start with the Upgrade checklist.
14· Run through the database upgrade steps in the AX checklist. During the post sync cockpit you may encounter some problems regarding data .. no worries just note them down and correct data in the SQL or AOT table browser. KEEP CHECKING ON THE SQL SERVER 2005 Activity Monitor (if there is any suspended activity for database AXDB2009_LIVE). If there is any then kill it and rerun the failed script in the post sync cockpit.
· Eventually the system will finish the upgrade checklist. Once done ---- hurray. Close the application client instance.
· Open the application client again . Uncheck the configuration key "Keep update objects 4.0" and Keep update object 4.1" in administration.
· Check the config key "Fill Utility" in administartion.