Print Page | Close Window

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 . ;-)

Think about it. I'll try to do it this week. :-)

Anyway, using a script would be much easier!!!




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