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:-
------------- 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 :
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
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 |