April 27, 2006 at 2:29 pm
Does anyone know of any tools to migrate iSeries database to Sql Server database?
April 28, 2006 at 7:07 am
Are you looking to do a 1 time migration or replication of from DB2 iSeries to Sql Server. We have used a product from DataMirror, http://www.datamirror.com, that does basically real-time replication and they probably have a product that can handle a 1 time migration.
You could also look into using DTS (SSIS on SQL2005) to do the data migration, you would probably want to create the database(s) and tables in SQL manually.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 28, 2006 at 7:58 am
I use DTS & Informatica PowerCenter for our ETL to send data to our BI Warehouse on a sql server.
Sending the data or creating the tables is not what I am looking for.
What I am looking for is to migrate, one time, the whole Library schema with all keys/constraints/relationships etc...
April 28, 2006 at 8:49 am
The AS400/iseries stuff I've pulled into SQL Server doesn't have keys/constraints/relationships at the tables (this is a well known ERP System). The application/RPG code has this integrity. You may need to spend some face to face time with your AS400 programmers and look at documentation to find out the application integrity.
There is a nice plugin for eclipse called clay that will map, reverse-engineer, and DDL the database. You might want to get an overview first to see if there are any relationships. This tool is where I started on my project.
http://www.azzurri.jp/en/software/clay/index.jsp
Kevin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply