as400 db2 to sql server 2005

Mingo

5 pts.

Tags:

AS/400 DB2

IBM DB2

SQL Server 2005

how can we take a db2 backup tape and dump to a sql server 2005 database?

Asked: May 28, 2008 4:47 PM Last updated: October 18, 2013 1:15 AM

Answer Wiki

Last updated: October 18, 2013 1:15 AM GMT

Denny Cherry68,390 pts.
History
Contributors
- Ordered by most recent
- Denny Cherry68,390 pts.
- alessandro.panzetta9,725 pts.

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

No you can not take a DB2 backup and restore it to a SQL 2005 database. You will only be able to restore it to another DB2 database. In order to transfer your data from a DB2 system to a SQL Server (or any other database) is a manual process.

First you will need to create all the tables. You can usually do this by scripting out the tables using the DB2 tools then making some modifications to those scripts and running them against the SQL Server database. You can then use the SQL Server Integration Services to migrate the data from the DB2 database into the SQL Server database.

==========================================================

You will only be able to restore it to another DB2 database.

Actually, you can only restore it to another AS/400 that is at a compatible release level. The AS/400 backup cannot be restored to DB2 on any other platform. If a migration is intended, then the system backup facility is not appropriate.

Tom

Discuss This Question: 2 Replies

Denny Cherry May 29, 2008 1:30 AM GMT

Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.

68,390 pointsBadges:

report
RossHowatson Apr 23, 2010 2:23 PM GMT

Create an empty table in SQL 2005 (i.e. as400data) On the AS/400 use any programming language or Query/400 (ugh) to write out the table data to a file on the AS/400. The basis of the output will be as follows: insert into as400data values('textfield1', 'textfield2', numericfield1, numericfield2, ...); insert into as400data values('textfield1', 'textfield2', numericfield1, numericfield2, ...); insert into as400data values('textfield1', 'textfield2', numericfield1, numericfield2, ...); From this file simply import this file to your PC as a text only file called as400data.sql Run the as400data.sql from within SQL.

540 pointsBadges:

report