Web Wiz Forums - Conversions

Print Page | Close Window

Conversions

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=5771
Printed Date: 03 April 2026 at 6:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Conversions

Posted By: wfusco
Subject: Conversions
Date Posted: 15 September 2003 at 9:30pm

Can you convert an existing 7.0 access database version over to SQL without loosing any existing data?

Wayne

Replies:

Posted By: wistex
Date Posted: 15 September 2003 at 10:15pm

I know that if you are using SQL Enterprise Server, you could do an import from Access that will import all your tables and data. You can also export it back into Access as well.

There is also something called an Access Upsize Wizard that people keep talking about. Since I started with SQL, I never had to use it. Apparently it helps you convert from Access to SQL.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: wfusco
Date Posted: 15 September 2003 at 10:31pm

Greetings Scott,

I do believe that I do have the enterprise version but what if its not? I am torn between installing SQL or not. I am not good at databases but know that there is a ton of added proformance with SQL

Wayne

Posted By: wistex
Date Posted: 15 September 2003 at 10:39pm

It will be worth it due to the performance and scalability.

I was searching through this forum and there is a Access Upsize Wizard that converts to SQL. You would use that for your conversion.

There are a lot of areas where you could mess up. I suggest doing a search on it to see the various discussions. And making sure you do a back-up before you do anything.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: wfusco
Date Posted: 16 September 2003 at 6:40am

Hey Scott

I assume that you are using SQL with your forums?

Posted By: God_Struth
Date Posted: 16 September 2003 at 10:28am

Trying to upgrade the database from access to SQL is a hit and miss affair, I have read here that several people have managed it succesfully but having tried it several times myself I have been unable to do an error free upgrade.

Without doubt the SQL version is the way to go though.

Posted By: wfusco
Date Posted: 16 September 2003 at 12:14pm

Okay well I am trying to use the upsize wizard to creat a new database. Now I either get a logon error which I can not figure out or I get an access error message that simply saids overflow. I know this is limited information but I hope that someone can give me a little guidence here..

Wayne

Posted By: God_Struth
Date Posted: 16 September 2003 at 7:54pm

First thing you have to do is make a blank database on the SQL server using the script that comes with the SQL version forum, this ensures you are using the stored procedures with the SQL version.

Then you have to use the upsize wizard to import the data from the access DB. I don't recall right now, but there are a couple of other steps involved when importing the data, you'll have to look for the post its explained in elswhere on the forum here.

Posted By: whittibo
Date Posted: 17 September 2003 at 8:40am

I think there is a SQL version of the forum that you would need to use too.

I didn't do mine.. I had to switch to SQL, but had the host set it up for me.. it was WELL worth the money and they gave me a great deal!

but yes.. the SQL version runs loads better, faster, smoother! good luck to you!

-------------
Live and learn through trial and error ~ when all else fails, ASK!

Posted By: wfusco
Date Posted: 17 September 2003 at 10:55am

Okay,
I think that I have done everything. I downloaded the SQL Version. I created a blank database. I modified the sql server script with my server name username and password. I ran the msqsl_serve_setup script. Now this might be a stupid question but, how do I knwo for sure that the forum IS using the sql server database?

Wayne

Posted By: wistex
Date Posted: 18 September 2003 at 11:49pm

Well, if it is up and running, one way to do it is create a new useraccount, and then go into the SQL database and look in the tblAuthor table and see if the new user is in there.

And, yes, I am using the SQL Version. We already use asp and SQL for the rest of our site, so when we added the forum, we selected an asp and SQL forum to integrate with the site. We never messed with Access at all.

-------------
http://www.wistex.com" rel="nofollow - WisTex Solutions
http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums

Posted By: wfusco
Date Posted: 19 September 2003 at 6:58am

Oh Yea, Its in there. Thanks.

I am still figuring out how SQL works.... At some point I want to upgrade to the new beta of the forums oage. Does that mean that All I have to do is point the new config to the SQL server and I should be back to where I am now?