Why Move to MySQL from Microsoft SQL Server?

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS Why Move to MySQL from Microsoft SQL Server?
# 1  
Old 05-04-2009
Why Move to MySQL from Microsoft SQL Server?

Before we get started, let me say that I always liked being a SQL Server DBA. My database experience started with DB2, then Teradata, followed by Oracle, and then SQL Server (and then a little bit of Sybase after that, followed by MySQL). Coming from the other databases, I found SQL Server the easiest and quickest to learn at the time, but of course, a lot of that had to do with the fact that Microsoft was really the only database vendor around then (I started with version 4.2 of SQL Server) that shipped any decent GUI management tools with their server. Take the tools away, and you basically had Sybase on Windows with the ISQL command line tool, which was not pretty by any means.

More...
Login or Register to Ask a Question

Previous Thread | Next Thread

3 More Discussions You Might Find Interesting

1. SuSE

Syslog-ng 3.0.7 fails to insert into microsoft sql server

Dear All, Im currently configuring syslog-ng on SUSE Linux 10 SP2 to communicate with microsoft sql server 2005. I have installed freeTds 8.0. Tested TSQL ..works fine ISQL works fine. when testing with syslog-ng destination d_mssql { sql(type(mssql) host("ip address")... (0 Replies)
Discussion started by: SystemEng
0 Replies

2. Shell Programming and Scripting

Connection to Microsoft SQL Server

Hi, I am using "ksh" and trying to connect to the Microsoft SQL Server but it gives an error that is: DB-LIBRARY error: Unexpected EOF from SQL Server. Can any one please help me to resolve this issue. And i am using Putty to connect to the Unix server. Thanks (3 Replies)
Discussion started by: anupdas
3 Replies

3. Shell Programming and Scripting

(perl) Microsoft SQL Server client for solaris. cant find it...

let me save everyone the pain that it caused me. This is all free. And make sure it is in this order 1) make sure you have the latest version of perl installed 2) make sure you have NET:aemon installed 3) make sure you have RPC::PlServer & PlClient (the bundle has both) 4) make sure... (3 Replies)
Discussion started by: Optimus_P
3 Replies
Login or Register to Ask a Question
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::CuUser(Contributed Perl DocumDBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)

NAME
DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor - Remove trailing NULLs in binary data and normalize GUIDs for MSSQL over ADO DESCRIPTION
This class is for removing trailing "NULL"s from binary data and removing braces from GUIDs retrieved from Microsoft SQL Server over ADO. You probably don't want to be here, see DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server for information on the Microsoft SQL Server driver for ADO and DBIx::Class::Storage::DBI::MSSQL for the Microsoft SQL Server driver base class. Unfortunately when using DBD::ADO, binary data comes back padded with trailing "NULL"s and GUIDs come back wrapped in braces, the purpose of this class is to remove the "NULL"s and braces. DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server sets cursor_class to this class by default. It is overridable via your connect_info. You can use DBIx::Class::Cursor::Cached safely with this class and not lose the binary data normalizing functionality, ::Cursor::Cached uses the underlying class data for the inner cursor class. AUTHOR
See "AUTHOR" in DBIx::Class and "CONTRIBUTORS" in DBIx::Class. LICENSE
You may distribute this code under the same terms as Perl itself. perl v5.18.2 2013-12-16 DBIx::Class::Storage::DBI::ADO::Microsoft_SQL_Server::Cursor(3)