473,387 Members | 1,481 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Sysbase to Db2.

All:

We are evaluating for possible migration and I would like to invite
comments on what are the reasons for Migrating database from Sybase to
DB2.

Any pointers?

TIA

Nov 12 '05 #1
1 1817
Disclaimer:
1. I work for IBM
2. I deal a lot with migrations.

There are several general reasons for DBMS migration I can think of:
* company strategy (reduce number of involved DBMS vendors)
* TCO (Total Cost of Ownership)
* scalability limits
* performance
* support by the application vendor
* long term viability of the DBMS vendor
* need to exploit features the current DBMS does not provide
(or is not expected to provide in the timeframe needed)
* integration with the software stack

Bad reasons:
* Personal preference of DBA, Developers, CIO
* Watching marketing slides

Migration is serious business. Make sure you go into it open eyes.
Migration can only succeed with buy-in of the IT department.

Cheers
Serge
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: WGW | last post by:
Though I am a novice to MS SQL server (2000 I believe), I can do almost! everything I need. Maybe not efficiently, but usefully. However, I have a problem -- a complex query problem... I can...
1
by: utkanbir | last post by:
Hi , This is related to datawarehouse , data mining . We are told that data mining tools such as spss or sas , need a large table which has lots of columns inside . Based on our project , out...
2
by: The Crab | last post by:
Hello, We are planning to convert an application with lots of Stored Procedures from Sysbase on Unix to DB2 on OS/390. We are basically looking for white papers / documentation / toolkits on...
0
by: utkanbir | last post by:
Hi , This is related to datawarehouse , data mining . We are told that data mining tools such as spss or sas , need a large table which has lots of columns inside . Based on our project , out...
2
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
4
by: R | last post by:
Hi When an Access query is run against an ODBC table, is it possible in any way to tell what is passed to the server? I have a remote Sybase database linked into Access and the bandwidth is...
9
by: Paradigm | last post by:
I am using an Access2K front end to a MYSQL database. If I enter a new record in a continuous form the record appears as #deleted as soon as I move to a different record in the form until I requery...
9
by: Chris | last post by:
If I use Perfmon to look at the number of GC Handles for my application, and it stays about the same over several hours, I don't have an issue with freeing up unmanaged resources in my app. Is...
0
by: niraj.kumar.ait | last post by:
Hi I want to access the mssql database through c++ in linux. I dont want to use sysbase and php is it possible .I have freetds 0.63 . with regards Niraj
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.