should i upgrade

[earlrainer]

Hi,
We use sybase 6.0 in our software products.
now we are at a point where we have to decide whether we retain sybase 6.0 or upgrade to sybase 9 (if thats the latest unbuggy one) or simply shift over to another database like SQLserver or Oracle.

our programs are basically sales related software ,where there are quite a number of medium sized tables(about 10,00,000 records) and sometimes the select queries run very slowly.
that is why we have been advised by some,to move over to other databases.

thanks

but we still want to retain sybase .will upgrading to sybase 9 be of any help? or is it better to shift

 

[LucieLastic]

hi EarlRainer

I suppose it depends how big your databases are going to get, if they're going to be millions of records in several tables with high speed access, maybe you need Oracle but I think it's very expensive - don't know much about it.

Personally, if it is a choice between Sybase and SQLServer, I'd move to SQLServer, simply because (I think) there's more support and books available. For example, the SQL server forum on Tek-Tips has a very high message/reply turnover. I'm also a little more familiar with the management tools of sql server (ie Enterprise manager) than I am Sybase Central which I get frustrated at the Java version - so I may be a bit bias .

lou

 

[JeanNiBee]

I wouldn't use the size of a support forum as the basis of an upgrade or not.

Sybase has lots of support aside from Tek tips. The largest of which is their newsgroup. They also publish all their books free in pdf format on their website. They have User, Admin, Performance, high Availability etc etc all online, and ALL very very informative.

How many books do you need telling you how to write select statement?

Base your upgrade on the fact if you need the new features. Oh yeah, Sybase ASE is now in version 12.5.0.3 as the latest stable release.

You can check out

http://www.sybase.com/products/databaseservers/ase

and see the 'what's new for ASE to determine if you should upgrade, bit since you have SUCH an old version, I do suggesst you upgrade.

Hope this helps.


-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR][/COLOR] and

[/ignore] tags.

Ex:

SELECT 1 from sysobjects

 

[LucieLastic]

earlrainer

I think you should take JeanNiBee's advice as I really don't know what I'm talking about and still learning about Sybase and what's available out there (support/book-wise).

lou

 

[nickpark]

earl, dont underestimate the effort involved in a database platform migration ! Especially to oracle. Moving from Sybase to mssql would be easier and cheap. Moving from Sybase ASA to Sybase ASE would be easiest and you get the scalability of Unix.

Upgrading your ASA version is probably the simplest improvement and hopefully without many licensing implications.

Optimising the application design is the best way of performance gains ! A select in Sybase will take the same time in Oracle. (excuse the gross generalisation). If you need to look into this seriously, you wont find the answer of tek-tips - you need a detailed analysis !

rgds,
Nick