Home > IT Answers > AS/400 > Migrating from AS/400 to SQL Server
Dharder
15 pts.
 Migrating from AS/400 to SQL Server
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.

Software/Hardware used:
ASKED: July 8, 2010  4:41 PM
UPDATED: October 20, 2010  6:46 AM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  July 9, 2010  6:10 pm  by  DanD   0 pts.
All Answer Wiki Contributors:  DanD   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Rajat,
I am looking for technical support here, not marketing or sales pitches,

Dharder

Dharder
 15 pts.
 

Dharder,

He has been blocked from the site for misuse of the forums.

Thank you!

MelanieYarbrough
 6,315 pts.
 

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

TomLiotta
 108,005 pts.
 

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.

PierreArmand
 30 pts.