Migrating from AS/400 to SQL Server

15 pts.
Tags:
AS/400 DB2
AS/400 migration
AS/400 SSIS
SQL Server migration
We have an AS/400 that no one in our agency knows anything about except that it has been running for a few years and the data needs to be removed from the AS/400 to another platform, either DB2 or SQL Server. I have read that a SQL ssis package can be used to migrate the data - I need to know what information is required from the AS/400 to use an ssis package and how do I get that information? We have one userid that works but I do not know the authorization level. I recall there is a system operator signon but I do not remember it. I have some experience with the AS/400 but not enough to tackle this. Any help will be greatly appreciated.
ASKED: July 8, 2010  4:41 PM
UPDATED: October 20, 2010  6:46 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

A product for DB2, DB2 Connect can connect a DB2Uninversal data base to iSeries DB2-400. It is a DRDA connection and runs much faster than ODBC. If you decide to move the data to MSSQL then can use Microsoft Access but it is ODBC and would be very slow for a large database.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Dharder
    Rajat, I am looking for technical support here, not marketing or sales pitches, Dharder
    15 pointsBadges:
    report
  • MelanieYarbrough
    Dharder, He has been blocked from the site for misuse of the forums. Thank you!
    6,345 pointsBadges:
    report
  • TomLiotta
    If this involves an older "AS/400", migrating the data is probably the trivial part. It will more likely be the business rules locked in application code that will be the problem. It's quite possible that there is no 'migration' that can be done beyond simple data. It is very likely that everything will have to be re-engineered -- including the database which might not map well to MS SQL. Tom
    125,585 pointsBadges:
    report
  • PierreArmand
    We tried the DB2 Connect software. it was doing the job about the connectivity, but quite expensive for very little use use. The AS400 (in v6r1) is already an SQL server. Instead of DB2 connect, we are using IBM Data Studio 2.2 (Free of charge), to maintain the database and develop stored procedures. All by using SQL. For the SDK we purchase the i5_dotnet product. We are developping with Visual Studio 2008, in visual basic. No extra server is needed (unlike DB2 Connect), it is fast, and the third of the DB2 connect price.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following