Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 SQL Server vs MySQL
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Id
Junior Member

USA
129 Posts

Posted - 16 July 2001 :  17:22:59  Show Profile  Visit Id's Homepage
I've never messed with either of them, but i'm thinking I'm going to be upgrading from Access to one of them, basically so i can learn how to work them, as well as added speed and the like. My main question is, how limited is MySQL compared to SQL server. Are there any main limitations the one has over the other? Or am I going to be getting pretty close to the same thing if I went with either. Also what about Jet OLEDB drivers for MySQL? am I going to have to download anything for it, or does win2k Advanced Server come with them already?

Doug G
Support Moderator

USA
6493 Posts

Posted - 16 July 2001 :  18:30:11  Show Profile
Price is one of the main differences. SQL Server is expensive, MySql is free.

I'd pick SQL Server for ASP. MySql isn't that common on Windows platforms. SQL Server offers many features not available in MySql.


======
Doug G
======
Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 16 July 2001 :  18:52:42  Show Profile  Visit Id's Homepage
do you know what i'd be looking at as far as licensing would go? More specifically if i wanted it to be used purely for web based deployment, would i need anymore than say 5 user licenses?

Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 16 July 2001 :  23:54:17  Show Profile
You can get a 120-day evaluation version of SQL Server 2000 for around 4 or 5 bucks (US) for shipping a CD. There may be a download, I seldom check being stuck on a dialup connection.

SQL Server 7 Developer edition is available with many of MS Developer tools, like InterDev, Visual Studio, VB, Office Developer, etc. I have Visual Studio Enterprise which came with a complete MS Backoffice 4.5 developer edition. However, you need to own one of the develper packages which are not cheap.

MSDE is probably suitable for development, with maybe Access 2000 for maintaining the DB's. MSDE is included with Access 2000 and various developer tools. So if you have A2K, you already have a SQL Server 7 look-alike development environment.

I'm not too up on retail pricing for SQL Server, I believe there is an additional internet license if you want to host your own SQL Server based web site. I think retail prices are on the MS website in the SQL Server home area.


======
Doug G
======
Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 17 July 2001 :  13:31:00  Show Profile  Visit Id's Homepage
well i've got access XP and Access2k, does MSDE get installed with it or do i have to do something extra to get that working? I've messed around a little bit with access projects and it was asking for a sql server, though i wasn't sure quite what to do with it.

My main problem is i don't know anything about SQL server, i've learned all my asp with access, so i'm trying to branch out into the realms of SQL server and the like, so I'm sorta just poking and prodding with this trying to figure out how everything works

Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 17 July 2001 :  15:42:17  Show Profile
You have to install MSDE on purpose, it doesn't get installed by default. In Access 2000 anyway (I don't have XP yet), just enter MSDE to the Answer Wizard and read the help that comes up. One of the pages has detailed information on how to install MSDE, one has links to the SQL Server Books Online which completely documents SQL Server (and MSDE).

Get MSDE installed, read some of the help, and then open an Access Project and connect it to your MSDE server. You can create a new db or connect to an existing db.

The best I can say is that SQL Server is Access's Big Big Brother. You'll use a lot more SQL and less drag n drop working with SQL Server.




======
Doug G
======
Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 17 July 2001 :  16:27:21  Show Profile  Visit Id's Homepage
Thanks for your help, I'll definitely have to look into this. I also downloaded the Trial version of SQL2000 but i'm sorta lost on it, so i'll look into MSDE and see what i can figure out with that, and then move on to SQL

Thanks again

Go to Top of Page

camusflage
Starting Member

USA
26 Posts

Posted - 17 July 2001 :  17:50:00  Show Profile
My suggestion would be to gut it out with SQL. MSDE and SQL share a lot of the same code under the covers, and something tells me the docs for SQL are a lot better than for MSDE.

Mike


Go to Top of Page

h20
Starting Member

39 Posts

Posted - 17 July 2001 :  19:08:03  Show Profile
We just purchased a copy of SQL server. The best bet for SQL servers running on IIS is to pay for the processor license. Which basically means that you can have as many connections that IIS can handle with respects to how many processors SQL is licensed and configured for.

We purchased a two processor license at 4000 a processor. Out the door we had an SQL license for a two processor machine for just over 8000.

This is a fairly steep price... but man it is so neat how Win2k Computer Management interface ties into the SQL service... I have also read documents that SQL 2000 is the fastest DBMS for win2k... even faster that Oralce 8i.

Scott

Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 17 July 2001 :  20:05:13  Show Profile
quote:
... and something tells me the docs for SQL are a lot better than for MSDE

There are no separate documents for MSDE. You use the SQL Server Books Online with MSDE, just ignore much of the server administration docs that apply to Enterprise Manager. If you already have Enterprise Manager from another source, you can use it with your MSDE database.

I have developed applications using MSDE for small businesses, and have not had any difficulty using either MSDE or SQL Server 7 on the same database files. You can detach a db from SQL Server and attach it to MSDE, and vice-versa. There are some incompatibilites, the biggest issue is limitations on replication.

So my recommendation is if you want to learn SQL Server and have a budget, learn it with MSDE which costs nothing additional if you already have Access 2000. If you want to put something in production with over 5 or so users then SQL Server will be better than MSDE. MSDE is quite adequate for a small business Intranet and the price is definitely right.


======
Doug G
======
Go to Top of Page

Id
Junior Member

USA
129 Posts

Posted - 17 July 2001 :  20:38:06  Show Profile  Visit Id's Homepage
I'll say the price is right, free I can afford that :D

Anyway, thanks for all your input, i just need to figure out how to make asp work properly with SQL/MSDE

Go to Top of Page

pfilias
New Member

69 Posts

Posted - 18 July 2001 :  08:08:25  Show Profile  Send pfilias an AOL message  Send pfilias a Yahoo! Message
MSDE stands for Microsoft SQL Server Desktop Engine

Go to Top of Page

mrWize
deleted

119 Posts

Posted - 18 July 2001 :  10:55:13  Show Profile
quote:
Price is one of the main differences. SQL Server is expensive, MySql is free.


Read the Licens on www.mySQL.com

As I understand it, it´s free in some cases....evaluation, development (as long as You not sell your application)

cya,
mrWize

Go to Top of Page

mrWize
deleted

119 Posts

Posted - 18 July 2001 :  10:59:09  Show Profile
A Quote from www.mySQL.com
quote:
Running a Web Server using MySQL

If you use MySQL in conjunction with a Web server on Unix, you don't have to pay for a license.

This is true even if you run a commercial Web server that uses MySQL, because you are not selling an embedded MySQL version yourself. However, in this case we would like you to purchase MySQL support, because MySQL is helping your enterprise.



cya,
mrWize

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07