Should I use MySQL or SQL Server ?

Simon,

If you’re porting from Microsoft Access you want to use MS SQL. If your using ASP/Access you’re probably on a NT web host anyways, which probably only supports MS SQL (not many support mySQL).

>> Which one would you recommend the most?

It depends on what I’m doing. I use them both, PHP = mySQL and ASP = MS SQL for the most part.

>> Is there more ressources on the net for learning MySQL or SQl Server?

Sure are. The one you might find the most valuable is Microsoft Access and SQL Integration Resources at:
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/acsqlres.htm

>> Does it cost more to buy the software for MySQL or SQL Server?

Unless you own and/or administer the server your host should supply the software. You may have to upgrade your hosting package to include an SQL database.

>> Is there one of them that is shareware or freeware?

MySQL has specific rules, however for the most part it’s freeware.

Good luck,

------------------
Adam
AIS Internet Solutions
[email protected]
www.aisinternet.com

Hi,

Thank you very much.

I would like to know what are the big diffences between MySQL and MS SQL Server.

Does MySQL and SQL Server work like MS Access, you do your database and then you send it online on the server?

Should I use both as you do? Why do you use both?

Bye

Simon Baillargeon

Simon,

SQL is an abbreviation for structured query language. SQL is a standardized language for requesting information from a database originally developed by IBM. There are different dialects of SQL including MS SQL, mySQL, mSQL, Oracle, Sybase, etc.

The first step in determining what dialect you should use is by asking your web host what they support. MySQL is somewhat limited compared to other SQL dialects but it’s perfect for the average database. Most UNIX web hosts provide mySQL and/or mSQL. Usually you would use PHP or Perl as your front-end language. MS SQL is Microsoft’s dialect of SQL. Most NT hosts provide MS SQL. Usually you would use ASP or Perl as the front-end. It could be used with PHP however not many NT hosts provide PHP.

Nether work like Microsoft Access, but you can publish Microsoft Access Databases to a MS SQL server. I use both because I develop web sites on both NT and UNIX platforms and program with PHP and ASP.

------------------
Adam
AIS Internet Solutions
[email protected]
www.aisinternet.com

Hi,

Thank you for all the information, you did send to me, it did helped me a lot.

Bye

Simon