Web Wiz Support and Community Forums : SQL Server or Access? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 04:07:55 +0000 Sun, 13 Feb 2005 20:13:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13780 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server or Access? : Actually the Developer Edition...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76250.html#76250 Author: michael
Subject: 13780
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.]]> Sun, 13 Feb 2005 20:13:47 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76250.html#76250 <![CDATA[SQL Server or Access? : Ginger wrote: Am I right in...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76220.html#76220 Author: dpyers
Subject: 13780
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".
]]> Sun, 13 Feb 2005 16:52:48 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76220.html#76220 <![CDATA[SQL Server or Access? : If you want to build and test...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76115.html#76115 Author: michael
Subject: 13780
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&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
]]> Sat, 12 Feb 2005 11:03:44 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76115.html#76115 <![CDATA[SQL Server or Access? : the forum has a SQL server Creation...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76110.html#76110 Author: dj air
Subject: 13780
Posted: 12 February 2005 at 7:41am

the forum has a SQL server Creation script where you specifcy the logindetails etc to the SQL server. then the page creates the table, storedprocedures 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 thedatabase on your machine .. you can even run the site on your localmachine linking to the SQL database on the remore server.
]]> Sat, 12 Feb 2005 07:41:34 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76110.html#76110 <![CDATA[SQL Server or Access? : Thank you for your input...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76108.html#76108 Author: Ginger
Subject: 13780
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.
]]> Sat, 12 Feb 2005 07:35:54 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76108.html#76108 <![CDATA[SQL Server or Access? : if your wanting to put it...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76106.html#76106 Author: dj air
Subject: 13780
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 thedatabase remotely or you can create a .project in access importing thedata from the remote SQL server.


Edited by dj air - 12 February 2005 at 7:27am]]> Sat, 12 Feb 2005 07:26:12 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76106.html#76106 <![CDATA[SQL Server or Access? : I don&#039;t mind using...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76105.html#76105 Author: Ginger
Subject: 13780
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.
]]> Sat, 12 Feb 2005 07:11:56 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76105.html#76105 <![CDATA[SQL Server or Access? : I had posted this is the original...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76102.html#76102 Author: dj air
Subject: 13780
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


Edited by dj air - 12 February 2005 at 7:04am]]> Sat, 12 Feb 2005 07:00:12 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76102.html#76102 <![CDATA[SQL Server or Access? : This is the part that you probally...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76095.html#76095 Author: WebWiz-Bruce
Subject: 13780
Posted: 12 February 2005 at 5:09am

This is the part that you probally need:-

Quote SQL Server 2000 EnterpriseEdition and SQL Server 2000 Standard Edition are the only editions of SQLServer 2000 that can be installed and used in live (deployed) serverenvironments.

Whatdoes this mean? Simply, if you are building a database or analysis applicationthat accesses SQL Server 2000, you must use SQL Server 2000 Standard or Enterpriseeditions. Other editions cannot be used in deployed, server solutions, due totechnical and licensing restrictions.


Edited by -boRg- - 12 February 2005 at 5:10am]]> Sat, 12 Feb 2005 05:09:48 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76095.html#76095 <![CDATA[SQL Server or Access? : With a 1,000 members I would certainly...]]> https://forums.webwiz.net/sql-server-or-access_topic13780_post76094.html#76094 Author: WebWiz-Bruce
Subject: 13780
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
]]> Sat, 12 Feb 2005 05:08:06 +0000 https://forums.webwiz.net/sql-server-or-access_topic13780_post76094.html#76094