Hi,

I want to move an Axapta database located on an Oracle databaseserver to a
Microsoft SQL 2005 server.

I would like to avoid writing an individual dataflow transformation for each
table and field in the database.
An example of a transformation could be: TXT == "\x0002" ? "" : TXT

Is it possible to script the creation of these dataflows ??
Maybe a link for examples/hints etc. ??


Thanks,
Kent

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

Microsoft has a set of tools for migrating Oracle to SQL Server 2005.
http://www.microsoft.com/downloads/d...displaylang=en

There are also some vendors with tools that can script out schemas and SQL
insert scripts, which can then be deployed on SQL Server.

"Kent" wrote:

There is some amount of hand holding that needs to be done before the SSMA
could work on Ax database. For example, all indexes on Oracle are created
using NLS_LOWER. This is not supported on SQL Server and the tool will
complain.

Also, there are some tables such as SQLSystemVariables that contain platform
specific syntax that the AOS uses. You cannot convert tables such as this
from Oracle to SQL Server.


--
This posting is provided "AS IS" with no warranties, and confers no rights
"Eric Russell" <EricRussell (AT) discussions (DOT) microsoft.com> wrote