| Author |
 Topic  |
|
|
Id
Junior Member
USA
129 Posts |
 Posted - 16 July 2001 : 17:22:59
|
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
|
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
====== |
 |
|
|
Id
Junior Member
USA
129 Posts |
Posted - 16 July 2001 : 18:52:42
|
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?
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 July 2001 : 23:54:17
|
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
====== |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 17 July 2001 : 13:31:00
|
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
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 July 2001 : 15:42:17
|
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
====== |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 17 July 2001 : 16:27:21
|
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
|
|
|
|
camusflage
Starting Member
USA
26 Posts |
Posted - 17 July 2001 : 17:50:00
|
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
|
|
|
|
h20
Starting Member
39 Posts |
Posted - 17 July 2001 : 19:08:03
|
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
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 17 July 2001 : 20:05:13
|
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
====== |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 17 July 2001 : 20:38:06
|
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
|
|
|
|
pfilias
New Member
69 Posts |
Posted - 18 July 2001 : 08:08:25
|
MSDE stands for Microsoft SQL Server Desktop Engine
|
|
|
|
mrWize
deleted
119 Posts |
Posted - 18 July 2001 : 10:55:13
|
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
|
|
|
|
mrWize
deleted
119 Posts |
Posted - 18 July 2001 : 10:59:09
|
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
|
|
|
| |
Topic |
|
Topic Locked
