Print Page | Close Window

Access / SQL differences

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=2118
Printed Date: 31 March 2026 at 3:37am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Access / SQL differences
Posted By: pedalcars
Subject: Access / SQL differences
Date Posted: 25 April 2003 at 7:27am
Couldn't find any previous reference to this, so:

I have a live v7 forum now, running on Access.

My friendly server owner has suggested moving to the SQL version, which I'm more than happy to do.

With the exception of the DB (naturally!) are there any differences between the distributions? If so, what? I don't want to start customising my installation now, if I have to replace all the pages when I move to SQL.

I see a lot of the .asp files have paired functions in (one for access, one for SQL) - does this mean there's just a single (or limited number of) files / variables one has to change?

Ta


-------------
http://www.pedalcars.info/ - www.pedalcars.info

The most fun on four wheels




Replies:
Posted By: WebWiz-Bruce
Date Posted: 25 April 2003 at 7:46am

Just change one variable in the common.asp files and add your SQL srever login details into the SQL_server_Connection.asp file fopund in the admin area.

'Database Type
'strDatabaseType = "Access"
strDatabaseType = "SQLServer"



-------------
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: pedalcars
Date Posted: 25 April 2003 at 8:03am
Fantastic, that's what I was hoping for. Top stuff.

-------------
http://www.pedalcars.info/ - www.pedalcars.info

The most fun on four wheels



Posted By: neilcarter
Date Posted: 25 April 2003 at 1:52pm

As the "friendly server owner" I thought I would give this a try. I have set up another copy of V7 on the server, created the database, and run the scripts to create the tabels etc. No problem I now have a working SQL version of the forum with no data.

I then tried to use DTS to move the data from the access database to SQL at it throws are3 large number of Violation of primary key errors. I would be grateful for any suggestions.

 

Neil



Posted By: pedalcars
Date Posted: 27 April 2003 at 9:33am
Ooh eck, that doesn't sound pretty...

Help, anyone? People must have done this before, although I guess the number of people who have migrated from v7 access to v7 SQL is going to be limited, v7 having only been out about a week!!

Ta


-------------
http://www.pedalcars.info/ - www.pedalcars.info

The most fun on four wheels



Posted By: WebWiz-Bruce
Date Posted: 27 April 2003 at 10:58am

Remove the database form the SQL server, then use the Access Upsize wizard to upsize the database choosing the option to create a new database on the SQL server and also make sure you arn't using a DSN with the upsize wizard otherwise it won't create the primary keys and default values.



-------------
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: michael
Date Posted: 28 April 2003 at 8:26am
But if you use DTS make sure to enable identity insert in the transformation options...

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net