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
MSSQL_CLOSE(3)															    MSSQL_CLOSE(3)

mssql_close - Close MS SQL Server connection

SYNOPSIS
bool mssql_close ([resource $link_identifier]) DESCRIPTION
Closes the link to a MS SQL Server database that's associated with the specified link identifier. If the link identifier isn't specified, the last opened link is assumed. Note that this isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution. PARAMETERS
o $link_identifier - A MS SQL link identifier, returned by mssql_connect(3). This function will not close persistent links generated by mssql_pcon- nect(3). RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 mssql_close(3) example <?php // Connect to MSSQL $link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi'); // Do any related operations here // Close the link to MSSQL mssql_close($link); ?> SEE ALSO
mssql_connect(3), mssql_pconnect(3). PHP Documentation Group MSSQL_CLOSE(3)