Dynamics Ax 4.0 Database upgrade for Oracle

Before starting the upgrade process do the following activities:

Create an empty Oracle 10g database. Microsoft dynamics will support Oracle 10g database only. While creating the database log in as an Windows Administrator
Use the following SQL statement for creating new user in Oracle 10g

CREATE USER "OPS$\" IDENTIFIED EXTERNALLY;
Grant rights to the user "OPS$\" as given below :
GRANT ALL PRIVILEGES, SELECT ANY DICTIONARY TO “OPS$\";
For upgrading the existing database, create the tablespace in Oracle 10g with the same name as in oracle 9. For New Installation create 3 tablespaces (AXTAB,AXIDX,AXTMP) as given below:

CREATE TABLESPACE AXTAB DATAFILE'D:\ORACLE\ORADATA\AXDB\AXTAB01.DBF' SIZE 3000M BLOCKSIZE 8192;CREATE TABLESPACE AXIDX DATAFILE'D:\ORACLE\ORADATA\AXDB\AXIDX01.DBF' SIZE 2000M BLOCKSIZE 8192;CREATE TEMPORARY TABLESPACE AXTMP TEMPFILE'D:\ORACLE\ORADATA\AXDB\AXTMP01.DBF' SIZE 1000M;COMMIT;
4.1. Create a schema with the name DBO.

There are two xpo files that need to be imported into your 3.0 client and run against the old 9i database as per steps below:

Import PrivateProject_UpgradeColumnList.xpo from the SP1 DatabaseUpgrade folder into your 3.0 system a. Open the form UpgradeColumnList from the imported project b. Click on the button Generate tables UPGRADECOLUMNS and UPGRADETABLES are created in your 3.0 db. They contain fields that need to be updated from int to int64


To trim the right justified fields: Import PrivateProject_LeftJustified.xpo from the SP1 DatabaseUpgrade folder into your 3.0 system c. Run the job MainJob from the imported project opens a form d. Click “Left justify all” and wait until it’s done

If you are running a Oracle version for Windows, It is recommended running the DB Upgrade tool on the same machine where Oracle 10g is installed using the Administrator account.

On the machine where you are running the DB upgrade tool, verify if you can connect to the Oracle 9 by testing it using the ODBC wizard. This is to make sure that there is no problem accessing the Oracle 9 database from that machine.

After completing the above steps, run the DB upgrade tool from the Dynamics 4.0 DVD. The explanation of the fields available in the oracle tab is given below

Source

· Source connect string: Type connection information for the source database (Oracle 9) in the format Server Name/SID.
· Schema owner: Type the name of the schema under which the database objects were created.
· User Name: Type the name of a user who has access to the source database.
· Password: Type the password of a user who has access to the source server.
Target

· Target connect string: Type connection information for the target database, where the new, preliminary Microsoft Dynamics AX database is stored, in the format Server Name/SID
· Use this schema: Type the schema name (DBO by default) for the new, preliminary Microsoft Dynamics AX database

Comments

Unknown said…
Thank you much for sharing this with us, I'm waiting for your upcoming blogs on AX 4.0 upgrade Your blog is nicely written and rich in content.
November 12, 2018 at 1:08 AM
Post a Comment

Popular posts from this blog

How to Setup Alerts in Dynamics Ax 4.0

INTRODUCTION This article describes how to set up Business Alerts in Microsoft Dynamics AX 4.0. This article also describes how to set the e-mail address from which Business Alert e-mail messages are sent. MORE INFORMATION Configure a user account to receive alerts To configure a user account to receive alerts, follow these steps: 1. In the Navigation Pane, click Administration, and then click Users. 2. Select a user, and then click User Options. 3. Verify that the e-mail address where you want the user to receive alerts is in the E-mail field. 4. In the Receive alerts every (minutes) box, type 1. 5. In the Pop-up link destination list, click To alert. 6. In the Send alert as e-mail message list, click Define on each alert rule. 7. In the Show pop-ups list, click Define on each alert rule, and then click Apply. 8. Close the Options window. Add the "E-mail distributor batch" job The "E-mail distributor batch" job is the batch job that monitors and sends e-mail messag
Read more

Radio Frequency Identification [RFID]

We are all aware that, Dynamics Ax supports RFID. The Article below will give some basic idea about the RFID. RFID or Radio Frequency Identification is the Auto-ID technology by which one can identify objects and track information about them wirelessly using radio waves. In the simplest terms an RFID system consists of a TAG (transponder) and a READER (interrogator). The technology of RFID deals with the remote collection of information stored on a tag using radio frequency communications. Information stored on the tag can range from as little as an identification number, to kilo-bytes of data written to and read from the tag, to dynamic information maintained on the tag, such as temperature histories. The information from the tag/reader combination is either presented to a human operator typically using a hand-held device or a host computer which automatically manages the information. Critical performance variables of an RFID system determine the cost of implementation. Read Range - R
Read more