Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Converting AIX data to SQL 2005

Posted on 2010-09-07
7
522 Views
Last Modified: 2013-11-17
I am trying to convert aix database to sql database to run on new prohet 21 windows app.
0
Comment
Question by:Randy Wake
7 Comments
 
LVL 10

Expert Comment

by:laneduncan
ID: 33620502
What kind of database is the source?  Oracle?  DB2?  MySQL seems unlikely... ?

That will be a primary determining factor in your next steps.
0
 
LVL 3

Accepted Solution

by:
Neurom earned 250 total points
ID: 33620538
0
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33620656
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:Randy Wake
ID: 33621007
It is the "Progress" database.
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 33621047
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
 
LVL 68

Expert Comment

by:woolmilkporc
ID: 33621471
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
 
LVL 68

Assisted Solution

by:woolmilkporc
woolmilkporc earned 250 total points
ID: 33621507
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question