Link to home
Start Free TrialLog in
Avatar of Randy Wake
Randy WakeFlag for United States of America

asked on

Converting AIX data to SQL 2005

I am trying to convert aix database to sql database to run on new prohet 21 windows app.
Avatar of laneduncan
laneduncan
Flag of United States of America image

What kind of database is the source?  Oracle?  DB2?  MySQL seems unlikely... ?

That will be a primary determining factor in your next steps.
ASKER CERTIFIED SOLUTION
Avatar of Neurom
Neurom
Flag of Italy image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of woolmilkporc
Migration Toolkit only supports migration to DB2 or Informix.

As far as I know prophet21 can import CSV data (and many more formats).

If you tell us what your AIX data source ("database") exactly is, we could perhaps help you creating CSV data from it.

wmp
Avatar of Randy Wake

ASKER

It is the "Progress" database.
When I converted a Progress database I dumped everything out in CSV and imported into SQL.  The reason was array fields in Progress.  There is no analogy to array fields in SQL Server.
Yep,

use progress' "export" which supports the "delimiter" option to create a .csv file (delimiter ";")

Then use this file with prophet21's import feature to get the data into its sql database.

wmp
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial