Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 06-02-2004, 03:52 PM   #1
Registered: Feb 2004
Posts: 141

Rep: Reputation: 15
MySQL - interchangable with MS SQL Server

My company runs a mostly novell network. I am slowing trying to introduce linux for basic services, ftp etc.

More and more frequently we encouter software products that require a MS SQL server (database progs, accounting software, etc).

Is MYSQL pretty much interchangeable with Microsoft SQL Server?

Is MYSQL easy enough to set up, backup, and administer for someone with great networking experience, but only a year or so of true linux experinece?

Can anyone share how they use MYSQL, thier experiences with regard to installing and administering it, etc...
Old 06-03-2004, 06:34 AM   #2
Registered: Apr 2003
Location: Bangalore,India
Distribution: FC2, RHES, RH9, FC3, FC1, Slackware 3.0
Posts: 208

Rep: Reputation: 30
at least i didnt have much trouble installing mysql when I was a though I did manage to take time to read through the big FAQ provided by mysql. I could sort out my problems and understood how to do things from that faq. and that was the first time I was working with databases.

I was also trying to move data (though not ms smql ->mysql) around and found this
Maybe you can try it out and tell me if its worth
Old 06-03-2004, 02:35 PM   #3
Registered: Sep 2003
Posts: 240

Rep: Reputation: 30
how about it's compatibility with software that is looking for a MS SQL database?
Old 06-04-2004, 04:25 AM   #4
Registered: Jun 2004
Location: Frankfurt/M Germany
Distribution: SuSE 9.3/10.2/10.3
Posts: 64

Rep: Reputation: 16
Instead of MY_SQL try Sybase ASE for Linux, why?
I don't know if you allready know, Sybase ASE and MS-SQL have a common base. The first releases of MS-SQL were built by Sybase. Later MS took over some developers and extendet it by them selfe. But under the hood, the architecture, especially stored procedures and so on are pretty the same. Therefore it's fairly easy to migrate from MS-SQL to ASE. SAP did the Linux migration for BusinessOne with ASE on Linux in less than a week

Old 06-04-2004, 11:25 AM   #5
Registered: Sep 2003
Posts: 240

Rep: Reputation: 30
great suggestion... thanks for the info bro...
Old 06-04-2004, 03:13 PM   #6
LQ Newbie
Registered: Jun 2004
Location: NJ
Distribution: RH9
Posts: 14

Rep: Reputation: 0
I've been running MySQL in place of a MS-SQL box for months now, and I have not had any problems. All of my web-related databases (ASP, .NET, and Java) work perfectly and Access even connects to it when I need it to. I don't know what software you are using that needs to have MS-SQL, but I am sure that you can just setup an ODBC (or JDBC) to your software to make it work. If you need help with it, please don't hesitate to email. Also check out a couple of other sites: (of course). -- They also have a great mailing list. -- They make a much better data/database converter than Intelligent Converters.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 03:20 PM
mysql sql statement help mrtwice Programming 4 12-02-2003 11:04 AM
SQL in MySQL oulevon Programming 1 12-06-2002 12:33 PM
MS SQL to MySQL jayakrishnan Linux - General 0 03-22-2002 04:17 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 11:54 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration