A Comparison of SQL Server 2000 With Sybase ASE 12.5 - Page 4
April 23, 2003
Both SQL Server 2000 and Sybase ASE 12.5 support the ANSI SQL-92 entry level and do not support the ANSI SQL-92 intermediate level. In the Features comparison section of this article I want to make a brief comparison of the SQL Server T-SQL with Sybase T-SQL dialect and show some SQL Server 2000 and Sybase ASE 12.5 limits.
Microsoft T-SQL vs Sybase T-SQL
Microsoft SQL Server and Sybase ASE have a common heritage because, until version 4.2, Microsoft simply licensed Sybase's database server software. So these products had one kernel. After version 4.2, these products have diverged. Microsoft has produced versions 6.0, 6.5, 7.0, and 2000 of Microsoft SQL Server, while Sybase has produced versions 4.8, 4.9, System 10 and System 11 of Sybase SQL Server and versions 11.5, 11.9, 12, and 12.5 of Sybase Adaptive Server Enterprise.
Because Microsoft SQL Server and Sybase ASE had one kernel, they have some similar features now. For example, the dialect of SQL supported by both Microsoft and Sybase is called Transact-SQL (T-SQL). To distinguish these dialects, we will call them Microsoft T-SQL and Sybase T-SQL accordingly. Both of these dialects are very similar, so the migration to SQL Server 2000 from the Sybase ASE 12.5 (or vice versa) can be made much easier than the migration to SQL Server 2000 from Oracle 9i or IBM DB2 v8.1.
This is the brief comparison of Microsoft T-SQL and Sybase T-SQL:
SQL Server 2000 and Sybase ASE 12.5 limits
Some SQL Server 2000 and Sybase ASE 12.5 limitations:
It is not true that SQL Server 2000 is better than Sybase ASE 12.5 or vice versa. Both products can be used to build stable and efficient systems and the stability and effectiveness of your applications and databases depend on the experience of the database developers and database administrator rather than from the database's provider. But SQL Server 2000 has some advantages in comparison with Sybase ASE 12.5 and vice versa.
The SQL Server 2000 advantages:
The Sybase ASE 12.5 advantages:
1. SQL Server 2000 Books Online