HELP: Newbie Question about Database in Linux

scli

I am using Microsoft SQL Server to develop applications. Recently, i am going to porting the Database into Linux Database, what should i do? are there any database in linux that would support storedprocedure that i have used extensively in SQL Server.

thanks a lot.

bernouli

why dont you use mysql? it works super together with apache and php

mattr

Sybase ASE would be your closest match as it also uses T SQL.

Frag

MySQL doesn't support stored procedures. (not till version 5)

PostgreSQL might be what your looking for. It has enterprise level features. This is a very nice and free (as in beer) database. I use it for many things.

There are many others that support linux as it's platform. Here is a link with a list of databases that run on linux.

http://cbbrowne.com/info/rdbmssql.html

Good Luck

Frag

scli

Thank you the advices.

Indeed, the situation is that i have a system(written in jsp) that is now running on SQL Server 2000 as the backend Database, and i am going to port the system to Linux.

However, the main problem in my case is that the Database(SQL Server) has near 2000 stored-procedures. And I am going to use Database in LInux platform instead of using window sql server.

I knew that there are tools that convert scheme form Sql server to Postgresql, but it seems that i have to rewrite those stored-procedures.

It would be a headache problem.

mattr

As I said Sybase uses T SQL and you probably would not have to re-write much.