Solved

DB2 to SQL Server 2008 migration

Posted on 2010-09-15
6
584 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 37

Expert Comment

by:momi_sabag
ID: 33686431
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
ID: 33686470
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
ID: 33686538
0
Containers and Docker for Everyone

Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.

 
LVL 16

Expert Comment

by:theo kouwenhoven
ID: 33692287
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
ID: 33692340
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
ID: 33722897
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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

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