Hi, I am about to start a new project where I will be converting a flat file calendar system to using an SQL database. I have a choice of using either MS SQL server 7 enterprise or MySQL, also I will be writing a new app in ASP which will also use the same database type that I choose for the calendar.

Anyone got any tech advice as to which database type is better.

cheers

chmod

If you are using ASP you'll want MS SQL, if you are using perl/php you'll want MySQL

Cheers Paul

Can one not run ASP on a linux/unix box using Chillisoft?

You see the most important thing for me is to start by using the most robust, scaleable, feature rich database+dbmanager, if 7 is better than MySQl or the other way round I will adapt to use it.

chmod

Sure....you'll have to use mysql then if you are using *nix as ms sql is for windows.

Yeah your right there..

What do you think of this setup:

Win2000 Advanced Server
MS SQL Server 7 Enterprise or MySQL
Perl

Then I can run my old Perl flat files as well as new Perl sql`s, as well as ASP, bottom line is which database server to use on a Win2000 machine?

Ta very much for any ideas, pitfalls, advantages.

chmod