MySQL

sirpimpsalot · 06-02-2004, 02:52 PM

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...

zeropash · 06-03-2004, 05:34 AM

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

t3___ · 06-03-2004, 01:35 PM

how about it's compatibility with software that is looking for a MS SQL database?

DiWi · 06-04-2004, 03:25 AM

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

t3___ · 06-04-2004, 10:25 AM

great suggestion... thanks for the info bro...

daemonspyre · 06-04-2004, 02:13 PM

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.