Thursday, October 27, 2005

 

MS SQL Server vs Sybase ASE

What is the difference between MS SQL Server and Sybase ASE?

Those that have seen both are probably struck by how similar they are. Why are they so similar?

Well, MS SQL Server gets it roots from Sybase. In fact, the first version, MS SQL 4.2, was Sybase SQL Server 4.0, and was designed for OS/2.

The NT port came out a few years later. The first version of MS SQL Server that was not based on Sybase SQL Server was MS SQL 6.0. Of course, that was based on 4.2 which was Sybase SQL Server 4.0, so the differences weren't great.

Over time the two have grown a little bit apart. Sybase SQL Server eventually changed its name to Sybase ASE (Adaptive Server Enterprise). But they both still use very similar variations of SQL called "Transact-SQL" or T-SQL. The differences between the two are largely cosmetic: for example, Sybase ASE allows for longer names and MS SQL has indexed views.

MS SQL Server is sometimes referred to as the "Windows version" of Sybase ASE. But Sybase ASE is available on Windows platforms. MS SQL Server's primary advantage is that it is generally cheaper and generally slightly simpler, wherease Sybase ASE is available on more platforms and is generally more configurable.

Comments:


really good piece of information, I had come to know about your site from my friend shubodh, kolkatta,i have read atleast nine posts of yours by now, and let me tell you, your site gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a lot once again, Regards, Difference Between sql and tsql


 
What do you think about your post now in 2014, How close are T-SQLs from both Sybase and MS SQL Server today ? Thanks!
 
اصبح الكثير يرد الانتقال الى مكان مناسب لتوفير مسكن اكثر امان للاسرة وراحة وتاقلم لهم لهم وعند البداء فى عملية النقل هنا ياتى العجز والازعاج الذى يواجه كثير من الاعائلات وهنا ياتى دور شركة ركن الرياض لخدمات نقل العفش بالرياض افضل شركة متخصصة فى خدمات نقل العفش بالرياض بافضل سيارات النقل المجهزة والمامنة على اعلى مستوى ضد الاخطار الجوية كما لدا الشركة اكبر وافضل فريق يمتكل الخبرة حول فك وتركيب العفش والتغليف اثناء النقل لمزيد من المعلومات او طلب الخدمة يرجى الدخول الى الرابط التالى شركة نقل عفش بالرياض
يوجد ايضا شركات اخرى تابعه لنا فى الرياض تقدم خدمة نقل العفش باعلى مستوى مماثل لنا تماما وبافضل الاسعار المناسب ويتم التعاقد معاهم ايضا من خلال شركتنا لاننا نعمل فى نفس المجال معا بكل راحة ويسر واليكم رابط الشركة الاخرة فى الرياض شركة نقل عفش بالرياض

 
Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?