How to cleanup a 6 yr old Sybase database which will be replaced in 6-9 months?

Question

How to cleanup a 6 yr old Sybase database which will be replaced in 6-9 months?

Tejwant Kaur-333539

SSCommitted

Points: 1647
More actions
June 4, 2006 at 7:45 pm

#60804

Dear All,
I just started at this organisation and have been given a task to cleanup a 6 year old Sybase database on version 11.9.2. This database is the core system database and there are plans to migrate to SQL 2000 in the next 6-9 months.
There is not much help available at work as everyone is used to running procedures the way they are and it is a pretty complex database. My manager wants me to do the cleanup before we migrate to SQL. I think we should be concentrating on the new design/requirements etc. However, this is my job, so have to do it.
What do you guys suggest I look at? Any ideas?
Regards,
TK

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323546 More actions · Answer 1

"cleanup" is such a broad directive; i think we could help better if you could identify specific subsections of the cleanup;

what does cleanup mean in your situation? normalization? standardizing address information? checking indexes and performance issues?

help us help you by giving us a bit more on what you are trying to accomplish.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 2

Sorry about that. I should have had explained it a bit better.

The main thing issues are its performance and security. So, indexes, any tables not being used, any poorly written stored procs, non indexed views (I think Sybase doesn't support indexed views) etc.

Many a times during the day users complain that they are stuck in the system, ie the system is hung. So, sometimes there is a process blocking everyone else, and we have to kill it. Is there any way to stop this from happening?

please help!

Thanks,

TK

Pam Brisjar SSChampion Points: 12094 More actions · Answer 3

Sybase is rather similar to MS SQL Server, so most of the cleanup you do in Sybase will only benefit you in your migration.

Here's a link to the online reference manuals:

http://manuals.sybase.com/onlinebooks/group-asarc/asg1150e/@Generic__CollectionView;pt=asg1192e

and a direct link to the performance tuning guide:

http://manuals.sybase.com/onlinebooks/group-asarc/asg1150e/perform/@Generic__BookView

If you have any specific questions, feel free to ask as I'm working in a shop that is working on its Sybase to SQL Server 2005 migration and doing cleanup along the way.

Tejwant Kaur-333539 SSCommitted Points: 1647 More actions · Answer 4

Thanks Pam. Glad to know you're kind of doing the same thing as me. Thanks again.

Ron Peters-339365 Newbie Points: 9 More actions · Answer 5

Hi all - the company I work for is ALSO migrating from and older Sybase DB "ASE 11.5.1" to SQL Server 2005. I have been tasked with finding a cheap AKA (free, LOL) migration tool. Before I waste a bunch of time looking, does one even exist? I am currently testing SQLWays with success but it does not meet the "cheap" criteria. Any help would be greatly appreciated. Otherwise they want us to write the tool ourselves.