Solved

Converting AIX data to SQL 2005

Posted on 2010-09-07
7
521 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
OfficeMate Freezes on login or does not load after login credentials are input.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

770 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