Web Wiz Forums - from Access to MSSQL version

Print Page | Close Window

from Access to MSSQL version

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=25516
Printed Date: 03 April 2026 at 8:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: from Access to MSSQL version

Posted By: sunrise69
Subject: from Access to MSSQL version
Date Posted: 02 April 2008 at 6:36am

Hi everybody!

I want to upgrade from 7.x (Access) to 9.x (MSSQL), but I need to save all my post and user data. Did anybody do this? What was problem?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 02 April 2008 at 11:34am

There are database upgrade tools to upgrade your Access database to version 9.x. These tools are found in the Web Wiz Forums download zip file.

Once you have upgraded your Access forum use the 'Upsize Wizard' in MS Access to Upsize the database to SQL Server. The one in Access 2007 is really good and use it quite often to move Web Wiz Forums Access databases to SQL Server.

-------------
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: sunrise69
Date Posted: 02 April 2008 at 11:39am

Thanks a lot!

Posted By: sunrise69
Date Posted: 07 April 2008 at 2:42pm

Hi Bruce!

I did this but I've got a few errors:

tblAuthor: Table was skipped or export failed

tblCategory: Table was skipped or export failed

tblForum: Table was skipped or export failed

tblGroup: Table was skipped or export failed

Are there any important options in Upsizing Wizard? This's the first time I use it.

I try to upgrade to existing SQL Server database that already has some forums.

Thank you in advance!

Posted By: WebWiz-Bruce
Date Posted: 07 April 2008 at 2:57pm

I would use Access 2007 for this as it is much more successful than other versions and not yet seen it fail, so couldn't comment on why you got these errors.

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