Need to upgrade an Access db to MSSQL?
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=11400
Printed Date: 30 March 2026 at 11:47pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Need to upgrade an Access db to MSSQL?
Posted By: MadDog
Subject: Need to upgrade an Access db to MSSQL?
Date Posted: 02 August 2004 at 9:53pm
|
I created a script in ASP that will convert a ASP database into a MSSQL database. I'm looking for someone with an Access database that wants to upgrade. Let me know if your interested. ------------- http://www.iportalx.net" rel="nofollow"> 
|
Replies:
Posted By: MadDog
Date Posted: 03 August 2004 at 2:41pm
|
no one eh? ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: dpyers
Date Posted: 03 August 2004 at 2:49pm
|
Is it for any Access DB, or for WWF DB's? I'd like to mess with it, but can't get to it for a week or so. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: MadDog
Date Posted: 03 August 2004 at 2:51pm
|
WWF. I need to be able to test the DB to make sure everything still works 100% ok. ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: dpyers
Date Posted: 03 August 2004 at 3:09pm
|
The only WWF access db I've got up is one I use for testing mods and stuff. Not really a forum that's in use so I don't think it'd give you an adequate test. Sorry. -------------
Lead me not into temptation... I know the short cut, follow me. |
Posted By: FLATLINE
Date Posted: 24 August 2004 at 8:07am
|
Is there anything we need for this, except an Access DB? Like, MSSQL support on the server? Because if yes, then that's probably why you didn't get many volunteers. ------------- Visit my site: http://darkgreen.service-club.net - DarkGreen HQ 
|
Posted By: JohnKn
Date Posted: 24 August 2004 at 3:36pm
|
I'd be willing to test it out. I'm about ready to upgrade my Access
version to MS SQL (MSDE anyway). I've used Enterprise Manager to upside
a WWF db to MS SQL in the past which still required a fair amount of
hand tweaking in the db to get it to function. If you've got a script to run, I'll give it a try. The WWF I'm running is 7.6, is that going to cause a problem? |
Posted By: MadDog
Date Posted: 24 August 2004 at 4:20pm
|
The only problem i have found with my script is that the Access DB has to be on the same server as the MSSQL Server. I have yet to find a way around this. If you are still interested let me know. But i need to test it locally first because i haven't touched the script in a few weeks now. I cant remember if i need to tweak it some more or not. ------------- http://www.iportalx.net" rel="nofollow">
|
Posted By: JohnKn
Date Posted: 29 August 2004 at 10:26pm
| Sorry for taking so long to get back to you, I didn't get the topic notification and then couldn't login. I'm still interested, just let me know when you're ready to send over the script. |
Posted By: Seba
Date Posted: 15 September 2004 at 3:32am
| I'm interesed to test script. Where i can found it? |
Posted By: fastfred
Date Posted: 15 September 2004 at 9:28am
|
I do have a 35 Mb MsAcces database. Right now i don't have the time for changnig to SQL (and the extra costs of hosting). If you have a place (send me a PM) where i can upload the database i might can help you i you want. ------------- 
|
Posted By: Bluefrog
Date Posted: 15 September 2004 at 10:47am
|
I'm curious as to why this would be needed when DTS works perfectly well. ------------- http://renegademinds.com/" rel="nofollow - Renegade Minds - Guitar Software http://renegademinds.com/Default.aspx?tabid=65" rel="nofollow - Slow Down Music |
Posted By: JohnKn
Date Posted: 15 September 2004 at 11:13am
|
DTS works for getting the data into the db if you have Enterprise
Manager, but it leaves several columns that need to be manually
changed. Things like the following are not correctly set by DTS: tblTopic: Topic_id - identity set to Yes, Identity Seed = last id tblTopic: moved_id - default value = 0 tblTopic: No_of_views - default value = 0 tblTopic: Locked - default value = 0 tblThread: Thread_id - identity set to Yes, Identity Seed = last id tblAuthor: Author_ID - identity set to Yes, Identity Seed = last id tblAuthor: No_of_posts - default value = 0 tblBanList: Ban_ID - identity set to Yes, Identity Seed = last id tblCategory: Cat_ID - identity set to Yes, Identity Seed = last id tblPMMessage: PM_ID - identity set to Yes, Identity Seed = last id tblPoll: Poll_id - identity set to Yes, Identity Seed = last id tblPollChoice: Choice_ID - identity set to Yes, Identity Seed = last id tblSmut: ID_no - identity set to Yes, Identity Seed = last id tblForum: Forum_id - identity set to Yes, Identity Seed = last id It's not difficult to manually do it, a bit tedious but it's not something you'd be doing often. If someone has a script to do it, why not use it? |
Posted By: Emiliano
Date Posted: 11 October 2004 at 2:03pm
|
I was reading this topic and thought: what if we make a very fresh new clean install of WWF on a MS-SQL database and then import our data from Access to it? We could change some identity fields before importing and restore them as identity after. Maybe this way we do not have to set all those default values . ;-) Anyway, using a script would be much easier!!! |
