https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 02:25:58 +0000 Thu, 03 Feb 2005 05:44:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=13605 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75386.html#75386 Author: WebWiz-Bruce
Subject: 13605
Posted: 03 February 2005 at 5:44am

The Access to SQL server post is a sticky topic at the top of the support forum.]]> Thu, 03 Feb 2005 05:44:56 +0000 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75386.html#75386 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75334.html#75334 Author: michael
Subject: 13605
Posted: 02 February 2005 at 4:27pm

You got the first step right, for the following steps, if you do a search, someone posted detailed instructions on how to Transform you data to SQL.]]> Wed, 02 Feb 2005 16:27:32 +0000 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75334.html#75334 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75327.html#75327 Author: polecat
Subject: 13605
Posted: 02 February 2005 at 3:36pm

Ok ... I NEED urgently to migrate my 91 MB access db to an SQL db....how should I do it???
I should download the WWF 7.9 SQL version....and then? How should I migrate the data???
]]> Wed, 02 Feb 2005 15:36:27 +0000 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75327.html#75327 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75286.html#75286 Author: WebWiz-Bruce
Subject: 13605
Posted: 02 February 2005 at 4:13am

Access by it's very nature of being a flat file system is naff as a database backend for a forum, whatever your size of forum.

Forums generally work a database very hard so on an Access version itplaces allot of strain on the web server using allot of resources.

Each time the database is accessed the entire Access database fileneeds to be loaded into the web servers memory, add to this Access'sconnection limit on a database and you are asking for trouble.

The connection limit is made worse on web servers with many having aconnection pool of 20 shared across an entire server for all Accessdatabases.

This means that you can for very small sites get away with using Accessas the backend for a forum, but for any site expecting more than just ahandful of posts a week, you should seriously look at using MS SQLServer as the database backend which doesn't have any of Access'slimitations mentioned above.

To backup an MS SQL Database, what I do, is install MS SQL Server onyour own home machine, then use the 'Export' Tools on the remote SQLServer to backup the database to the SQL Server running on my ownmachine.
]]> Wed, 02 Feb 2005 04:13:42 +0000 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75286.html#75286 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75285.html#75285 Author: Fx-1
Subject: 13605
Posted: 02 February 2005 at 2:53am

Hi all,

I now have 50mb for SQL server database's, and was consideringswitching my forum from the access version to the SQL server version.The forum is fine on the access version though, so I'm not sure if Ishould convert it to an SQL server version.  The forum only hasabout 50 users, and doesn't get many posts lately.

What I like about the access version is that I can back up the databaseby ftp'ing in and copying the database file. How would you backup upthe SQL server version?

Would I see any performance increase by going to the SQL server version?

Thanks all

Fx
]]> Wed, 02 Feb 2005 02:53:54 +0000 https://forums.webwiz.net/pros-and-cons-of-sql-server-version_topic13605_post75285.html#75285