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 ------------- 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 |