Web Wiz Forums - Upgrading from Access to SQL Server

Print Page | Close Window

Upgrading from Access to SQL Server

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=20736
Printed Date: 28 March 2026 at 5:59pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Upgrading from Access to SQL Server

Posted By: Charlie Goodwin
Subject: Upgrading from Access to SQL Server
Date Posted: 18 July 2006 at 9:02am

Hi,

I bought the Access WWF and started doing some prototyping for a web site I'm building.

I've found it great as a starting point, utilising all those common functions such as user maintenance, sending emails, date formatting etc.

I've also heavily relied upon the code to providing a general framework to building my asp pages. Don't get me wrong, I'm happy coding in vbscript but it's nice to work from a proven architecture.

What I want to know is, how much pain am I going to suffer changing over to MS SQL Server. I know the SQL Server version has been optimised for speed. Does that mean the Database access code is all different?

My access database does not hold any info I'm concerned about. I just want my pages to now sit on top of a SQL Server Database. So there are no migration issues.

Incidentally, where is the latest tool (preferably free) for manipulating SQL Server Databases on a remote server?

Oh Yeah, one last thing, do I need to pay for a SQL Server WWF as I've already paid for an access version?

Replies:

Posted By: Demon
Date Posted: 18 July 2006 at 9:15am

Moving to 8.x Support forum, since this deals more with support than forum modifications.

-------------
So Sayith the Demon.

Posted By: WebWiz-Bruce
Date Posted: 18 July 2006 at 10:55am

The SQL Server version uses the same database schema as Access, except some of the SQL is different so a variable needs to be set in web wiz forums to run different SQL for the SQL Server version.

SQL Server runs in a completly different way to Access, Access is just a flat desktop file which can not cope with more than a handful of users when used with a forum. SQL Server, though is a proper Database Management System (DBMS), capable of handling many 1000's of users and massive databases.

With SQL Server you don't connect to a flat desktop file like with Access, you connect to a database which is attached to the database server, in this case SQL Server.

Microsoft have the SQL Management Studio to connect to your SQL Server database, of which they have a cut down Express version which is available for free from their SQL Server web site.

Web Wiz Forums licenses are site licenses so as long as the forum is on the same domain you can use any version you like of Web Wiz Forums with your license.

-------------
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: Charlie Goodwin
Date Posted: 18 July 2006 at 11:15am

So as far as the code that talks to the database, it's not different?

It uses open, addnew, and execute commands just like your access version?

It doesn't utilise stored procedures then?

Posted By: WebWiz-Bruce
Date Posted: 18 July 2006 at 11:29am

It doesn't use stored procedures, but the syntax of the SQL Statements is slightly different.

-------------
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: picardnj
Date Posted: 08 September 2006 at 7:10pm

How hard is it to transfer the data from access to sql?
I have access and would like to switch to sql, what are you recommendations?