LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 06-02-2004, 02:52 PM   #1
sirpimpsalot
Member
 
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, 05:34 AM   #2
zeropash
Member
 
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

http://www.convert-in.com/sql2mss.htm
 
Old 06-03-2004, 01:35 PM   #3
t3___
Member
 
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, 03:25 AM   #4
DiWi
Member
 
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

Dirk
 
Old 06-04-2004, 10:25 AM   #5
t3___
Member
 
Registered: Sep 2003
Posts: 240

Rep: Reputation: 30
great suggestion... thanks for the info bro...
 
Old 06-04-2004, 02:13 PM   #6
daemonspyre
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:

www.mysql.com (of course). -- They also have a great mailing list.
www.db-tools.com.br -- They make a much better data/database converter than Intelligent Converters.
 
  


Reply


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 08:44 AM
Migrating from MS-SQL server to My-SQL emailssent Linux - Networking 2 02-07-2005 02:20 PM
mysql sql statement help mrtwice Programming 4 12-02-2003 10:04 AM
SQL in MySQL oulevon Programming 1 12-06-2002 11:33 AM
MS SQL to MySQL jayakrishnan Linux - General 0 03-22-2002 03:17 AM


All times are GMT -5. The time now is 12:09 AM.

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