Solved

DB2 to SQL Server 2008 migration

Posted on 2010-09-15
6
564 Views
Last Modified: 2012-05-10
Hi All,
I have a DB2 database and I want to migrate to SQL Server 2008.
can someone guide me with the process?
0
Comment
Question by:saratcm
6 Comments
 
LVL 37

Expert Comment

by:momi_sabag
Comment Utility
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
 

Author Comment

by:saratcm
Comment Utility
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
 
LVL 37

Accepted Solution

by:
momi_sabag earned 350 total points
Comment Utility
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 16

Expert Comment

by:theo kouwenhoven
Comment Utility
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
 

Author Comment

by:saratcm
Comment Utility
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
 
LVL 5

Assisted Solution

by:Brian Chan
Brian Chan earned 150 total points
Comment Utility
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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now