March 7, 2005 at 5:23 am
Hi,
we've been asked by a client to redesign a DB app which is currently using MySQL and running on UNIX. Given that MySQL still does not have a final release for 5.0 (which implements Stored Procedures) we are considering proposing moving to Sybase. I know that SQL Server's origins were as Sybase, but I have no idea how much Sybase has evolved since and - more importantly - if it still runs on UNIX.
Any suggestions would be greatly appreciated
Thanks
Mauro Ciaccio
March 7, 2005 at 6:31 am
Hi,
Yes Sybase is a great tool in market , last version is ASE 12.5.(1),runs on Linux,Unix and cover all aspects of a top RDMBS.
You can migrate from mysql to ASE with wizard.
Gabriel Stan
March 7, 2005 at 6:36 am
Hi,
thanks for the quick feedback. If you have worked with both SQL Server and Sybase, how would you rate the ease of switching between the two. Is there a significant hit in terms of gaining familiarity with the system [eg. debug, user/login admin, permissions, data types, etc.]?
Thanks
Mauro Ciaccio
March 7, 2005 at 7:11 am
The learning curve from SQL server to ASE is not difficult(especially if you work with MSSQl 6.5,many dbcc & sp are the same),rate is about 7 (for 1 to 10),data types are almost the same,the security groups are different name, but what is different is the arhitecture of cache,monitoring ,scripts for backup,(must to know Unix).
Gabriel Stan
March 7, 2005 at 7:22 am
It sounds like on the SQL side the transition is pretty straightforward, while on the DBA side a knowledge of UNIX is required.
Thanks for your help.
March 7, 2005 at 7:29 am
No so easy,but approachable ,for DBA Unix scripts is a must.
Gabriel Stan
March 8, 2005 at 8:39 am
If cost is an issue, you might consider PostgreSQL.
It is free and its target is Oracle in terms of functionality, so it has stored procedures, etc., and is much more functional that MySql. It runs on UNIX, LINUX, and MS Windows. Recently, commercial support is available too.
March 8, 2005 at 9:21 am
A few things I have learned in my 'database travels in Sybase/Unix land':
1) Get on very friendly terms with your Unix System Administrator.
2) Pick up the O'Reilly book on 'ksh' (korn shell) for scripting --> this is a must.
3) Make sure Sybase is installed under a 'sybase' login, NOT 'root'.
4) You'll need an X-Windows emulator (e.g. Hummingbird) for installation from a PC via a telnet connection.
5) When installing, make sure to read the OS patch list and make sure you meet or exceed it prior to installation.
6) Don't forget to update /etc/system for the 'maximum shared memory' Sybase will use (similar to 'min/max memory' and 'lock pages' in MS/SQL).
7) Install the latest and greatest EBF (Service Pack) right after initial installation.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply