Converting AIX data to SQL 2005

I am trying to convert aix database to sql database to run on new prohet 21 windows app.
Randy WakePresident & Cloud Solutions ArchitectAsked:
Who is Participating?
 
NeuromConnect With a Mentor Commented:
0
 
laneduncanCommented:
What kind of database is the source?  Oracle?  DB2?  MySQL seems unlikely... ?

That will be a primary determining factor in your next steps.
0
 
woolmilkporcCommented:
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
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
Randy WakePresident & Cloud Solutions ArchitectAuthor Commented:
It is the "Progress" database.
0
 
Chris MangusDatabase AdministratorCommented:
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.
0
 
woolmilkporcCommented:
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
0
 
woolmilkporcConnect With a Mentor Commented:
There is even a commercial tool available to simplify your task:

http://p21manager.com/index.php/import-module/overview.html

Alas not really cheap, price is about $$ 2,500.-



0
All Courses

From novice to tech pro — start learning today.