It can be done via DTS. Create the SQL Server database using AX.
Avoid copying SqlParameters (and probably some other system tables). You have to convert all empty strings (there are no NULLs in AX) from ASCII-2 to an empty string. Be very carefull with what type of Oracle-connection you choose (version of ODBC-driver) --- In [email protected], "James Flavell" <[EMAIL PROTECTED]> wrote: > > Hi everyone > > Has anyone done data migration of Oracle AX DB to SQL? > > Can it be done easily via SQL DTS or is there many differences in > table/fields? > > Things I am concerend are: > > Extra fields in table structures > > Field type differences and hence truncation etc > > Thanks > > James >
