Print Page | Close Window

SQL Server or Access?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=13780
Printed Date: 12 April 2026 at 4:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: SQL Server or Access?
Posted By: Ginger
Subject: SQL Server or Access?
Date Posted: 12 February 2005 at 4:29am
I must admit I'm a bit confused, I would like to add a Web Wiz Forum to my site. I currently use MS Access 2002, must I dump this in favour of MS SQL Server?
If so, there appears to be many versions of MS SQL Server available, Microsoft SQL Server 2000 Developer Edition from £37 and upwards to Microsoft SQL Server 2000 Enterprise Edition £8,900 considering it will be used in a closed community with say 1,000 members, what would be the correct version?



Replies:
Posted By: WebWiz-Bruce
Date Posted: 12 February 2005 at 5:08am
With a 1,000 members I would certainly use MS SQL Server.

The following document from MS explains the different versions:-

http://www.microsoft.com/sql/techinfo/planning/ChoosEd.doc - - www.microsoft.com/sql/techinfo/planning/ChoosEd.doc


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: WebWiz-Bruce
Date Posted: 12 February 2005 at 5:09am
This is the part that you probally need:-

Quote SQL Server 2000 Enterprise Edition and SQL Server 2000 Standard Edition are the only editions of SQL Server 2000 that can be installed and used in live (deployed) server environments.

What does this mean? Simply, if you are building a database or analysis application that accesses SQL Server 2000, you must use SQL Server 2000 Standard or
Enterprise editions. Other editions cannot be used in deployed, server solutions, due to technical and licensing restrictions.


-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting


Posted By: dj air
Date Posted: 12 February 2005 at 7:00am
I had posted this is the original threads thats now been deleted

how active is the boards likely to be?

it may only have 1000 members but are there lickly to be 50 on at a time etc. and if a lot of posts/topics etc

if so then it would be wise to go for te SQL version.

or yopu could start with the access version and then move to the SQL version (bare in mind tranferring can be a pain).

main things to think about are :

  • number of active users at one time
  • number of posts/topics/forums
  • how reliable/ stable the web server is
  • weather its worth the money (main one LOL)
this one is run off a SQL Database, both can be good, but SQL is better for searching and is more stable than Access

i would recommend SQL


Posted By: Ginger
Date Posted: 12 February 2005 at 7:11am
I don't mind using the SQL version, but I need some help on understanding how SQL Server works.
 
Am I right in thinking that I can develop everything on my 'local' PC using the low priced (£37.00) Developers Edition of MS SQL Server, I then upload it to my hosting site, who have MS SQL Server installer on their server and their software takes care of everything else.
 
In other words, there is no need for me to purchase MS SQL Server for about £1,222.00 in order to put a Web Wiz Forum on my site.


Posted By: dj air
Date Posted: 12 February 2005 at 7:26am
if your wanting to put it on the remote server (web server)

why not just install the forum straight onto the web server that way you don't need to waste money on the SQL server

you may need to get hold of Enterprise manager if you want to edit the database remotely or you can create a .project in access importing the data from the remote SQL server.


Posted By: Ginger
Date Posted: 12 February 2005 at 7:35am
Thank you for your input and help but I think that just went over my head, are there any good books or tutorials on the subject.
 
I'm obviously wrong in assuming that everything needed to be created on my local PC before uploading to my host.
 
I've heard of Enterprise Manager and the Access Project although I have not found out any info on the latter.
 
I'll go and do some seaching.


Posted By: dj air
Date Posted: 12 February 2005 at 7:41am
the forum has a SQL server Creation script where you specifcy the login details etc to the SQL server. then the page creates the table, stored procedures etc.

if you wanted the SQL server on your local machine just to create the forum database its not required

the file that creates the tables etc is the MSSQL_server_setup.asp file within the forum download.

you must set the server /database details within the SQL_serverconnection.asp file .

you only need SQL server on a local machine if you want to run the database on your machine .. you can even run the site on your local machine linking to the SQL database on the remore server.


Posted By: michael
Date Posted: 12 February 2005 at 11:03am
If you want to build and test your SQL DB locally you can also install the MSDE version of SQL Server, MSDE short for Microsoft SQL Server Desktop Engine has limitations in how big a DB can be and how many concurrent connections it can process but for local development it is more then enough.
 
You can download MSDE here
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en - http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&di splaylang=en
 
Though MSDE does not come with Enterprise Manager, I learned to love another tool that is easier to operate and much faster anyway, the LITE version which is enough can be downloaded here for free.
http://www.sqlmanager.net/products/mssql/manager/download - http://www.sqlmanager.net/products/mssql/manager/download


-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker


Posted By: dpyers
Date Posted: 13 February 2005 at 4:52pm
Originally posted by Ginger Ginger wrote:

Am I right in thinking that I can develop everything on my 'local' PC using the low priced (£37.00) Developers Edition of MS SQL Server, I then upload it to my hosting site, who have MS SQL Server installer on their server and their software takes care of everything else.
 
That's correct. As also noted above, you can used msde to develop locally as well. The SQL server developer edition is essentially MSDE plus tutorial (SQL Server Books Online), plus MS Enterprise Manager wich is an excellent tool fro transfering your local Developer DB to the Host as well as useful for a lot of admin tasks for both your developer and host ed versions of the DB.
 
INHO, geting MS Enterprise Manager (EM) is alone worth the price of the developer edition. There are other similar tools available, and some are free. However, every tutorial you run across for MS SQL server says things like "You then do X in EM , then you use the Y option to do Z in EM".


-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: michael
Date Posted: 13 February 2005 at 8:13pm
Actually the Developer Edition is the Enterprise Edition with a different License so you can do clustering etc.
Personally I do not think that EM is worth a penny, the only client tool that basically never has been done in any freeware is DTS, thus dPyerys being right just for DTS I'd spent the money as it is an invaluable tool to transfer data.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net