as400 db2 to sql server 2005

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: Last updated:
1

Answer Wiki

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

 
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.
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    69,125 pointsBadges:
    report
  • RossHowatson
    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.
    630 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.

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

Following

Share this item with your network: