| Author |
 Topic Search  Topic Options
|
Ginger 
Newbie
Joined: 12 February 2005
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: SQL Server or Access?
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?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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:-
www.microsoft.com/sql/techinfo/planning/ChoosEd.doc
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 12 February 2005 at 5:09am |
This is the part that you probally need:-
 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. |
Edited by -boRg- - 12 February 2005 at 5:10am
|
|
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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
 )
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
Edited by dj air - 12 February 2005 at 7:04am
|
|
Ginger
Newbie
Joined: 12 February 2005
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
Edited by dj air - 12 February 2005 at 7:27am
|
|
Ginger
Newbie
Joined: 12 February 2005
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
dj air
Senior Member
Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
