Re: Lawson Financials Oracle to SQL Server Conversion
From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Fri, 18 Nov 2011 13:48:00 -0600
Message-ID: <CAGRGHjyL-C70d7Maf7rHY6RAHrs+LjxnnkG3xovkWQQVdvBstA_at_mail.gmail.com>
Manjula,
I worked for Lawson several years ago. How much data do you have? Lawson has (well, had when I worked with it) built-in tools that can perform this conversion for you. You simply define a new data source in SQL Server and then execute a command to move your data from one system to another. The tables are exactly the same on both systems. My only reservation is if you have vast amounts of data such that the time might be longer than you like. Or if you have extremely stringent downtime requirements - but then next week is a Thanksgiving holiday :-).
Date: Fri, 18 Nov 2011 13:48:00 -0600
Message-ID: <CAGRGHjyL-C70d7Maf7rHY6RAHrs+LjxnnkG3xovkWQQVdvBstA_at_mail.gmail.com>
Manjula,
I worked for Lawson several years ago. How much data do you have? Lawson has (well, had when I worked with it) built-in tools that can perform this conversion for you. You simply define a new data source in SQL Server and then execute a command to move your data from one system to another. The tables are exactly the same on both systems. My only reservation is if you have vast amounts of data such that the time might be longer than you like. Or if you have extremely stringent downtime requirements - but then next week is a Thanksgiving holiday :-).
Dennis Williams
On Fri, Nov 18, 2011 at 1:01 PM, Manjula Krishnan <oradba.la_at_gmail.com>wrote:
> Hi guys/gals:
> I have been dropped a bombshell this morning. We are currently on AIX
> pSeries with database and application on the same box. Has anyone migrated
> the Lawson database from Oracle to SQL Server? How easy / difficult is the
> conversion? Are tables/data types etc the same? What is the performance
> impact of this?
>
> I am trying to collect information for a possible move from Oracle/AIX to
> SQL Server /Windows.
>
> Thanks,
>
>
> Manjula
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 18 2011 - 13:48:00 CST