DB2 to SQL Server 2008 migration

Hi All,
I have a DB2 database and I want to migrate to SQL Server 2008.
can someone guide me with the process?
saratcmAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
momi_sabagCommented:
which db2 platform?
i know microsoft has tools to convert oracle to sql server
pretty sure they have those for db2 as well
i can also provide such a service since i am familiar with both
0
 
saratcmAuthor Commented:
Thanks sabaq for the response,
from DB2 version 9.1 to sql server 2008/R2.
Can u provide me with migration from oracle 10g to sql server 2008?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
MurpheyApplication ConsultantCommented:
Hi saratcm,

Why this huge stap back :-)

oke, do you need a fuul copy or do you already have a DB definition of the new situatuion and only interested in coying the data?

regards,
murph


0
 
saratcmAuthor Commented:
Hi murphy,
I have 2 do everything from scratch, I don't have a database definition. I have to create.
can u pls give me your opinion too on both scenarios (having database already n need 2 do an import & steps to do form the scratch)
0
 
Brian ChanConnect With a Mentor DBACommented:
I have been in a similar situation but eventually we decide not to go ahead. General speaking, there are a few things you will need to worry when you migrating database across platform.

First, you will try to recreate the schema at the other end.
Then enable the connection between the databases on both platform.
Next is move to data across (think about SSIS).
After that, worry about is there is any stored procedure or function is not working with the new platform because the built-in function is not there anymore.
if you ever success after this point, do test it on your app. If you pass a good throughout regression testing on the app, then it should be good.

It is very broad overview and it is manual work. See if that is what you can manage to go through..

Good Luck.

DB Bunny
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.