Database migration from SQL to DB2

[BKisovec]

Hi ,
I am very sorry to bother you, but I am a student from Slovenia and we are having some problems with a project, where we have to transfer a database from MS SQL 6.5 /WinNT to DB2 / AIX (unix) and no one has had any experience with this kind of work. We should use the DB2 Universal database server on the new IBM RS/6000.

We would be happy for any help.

Best regards,
Bostjan Kisovec
bkisovec@iname.com

 

[Guest_imported]

Such migration is beyond AIX capability. Through you can make SQL Server and DB2 to exchange data through IBM's e-connector, MQSeries, I don't think there is a convenient way to do it offline.

 

[ElgisRamon]

How do you designed you database? Using a script with SQL DDL sentences? use it on DB2 to recreate your DB design on DB2.

Then export every and each of your MS SQL Server tables to tab or comma delimited text files and reimport manually each file on your tables and voilà.

I hope it works... ask if not.
I hope it works...
Unix was made by and for smart people.

 

[Sina]

You may also take a look at SQLPorter from realsoftstudio.com

The migration modules makes it very easy to migrate all tables remotly or over the web, regardless where your source and destination database reside.

you can see it at

http://www.realsoftstudio.com

Sina

http://www.realsoftstudio.com

SQLPorter Database Migration tools
Oracle, IBM DB2, SQL Server, MySQL
database migration made simple.

 

[Shaixpeare]

Hi Bostjan,
This is a piece of cake and something I've done more than once. First, download the free DB2 Migration toolkit from IBM at:

http://www-3.ibm.com/software/data/db2/migration/mtk/

It supports migration of SQL Server 6 & 7 and Sybase 11 databases and data. Whether the DB2 database is in NT, AIX or Solaris doesn't make any difference because you will catalog it locally on your Windows workstation (where the migration tools run) anyway. Let me know if you need any help. Enjoy!

 

[AIXSPadmin]

At my previos company I worked for, we went through a migration from one database (I don't recall what it was) to a different databse (UniVerse - I think they are out of business), and it took over a year for the complete migration. The setups were completely different, where the old system was running AIX 3.2.5 on a model 580 using Unibol36 to deploy RPGII apps, the new system went to UniVerse databases on AIX 4.1.5 on a model J40 with their programming language being UniVerse BASIC. Everything had to be recoded, and as stated, took over a year. Hopefully, your migration will be easier and better, though I am grateful for the experience and learning I gained from the pain!

Good Luck!