[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 533
  • Last Modified:

Converting AIX data to SQL 2005

I am trying to convert aix database to sql database to run on new prohet 21 windows app.
0
Randy Wake
Asked:
Randy Wake
2 Solutions
 
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
 
NeuromCommented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
woolmilkporcCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now