Import Webwiz Forum Access to SQL Server
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25382
Printed Date: 29 March 2026 at 3:12am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Import Webwiz Forum Access to SQL Server
Posted By: anngerilyn
Subject: Import Webwiz Forum Access to SQL Server
Date Posted: 03 March 2008 at 7:39am
|
Hi All, Anybody can give me some clues on how to import webwiz forum Access to SQL Server. Question1: I had downloaded webwiz forum Access database to see its function. My question is if i had already added quite many users inside, and also post inside are greater than 50 already. Do i have the option to import access database to SQL Server if i upgrade it. currently i saw an "Import" menu within webwiz forum access. will i also see this in webwiz forum SQL Server? Question2: 1. downloaded webwiz forum access database 2. added 50+ users or posts/topics 3. uninstall webwiz forum access database 4. downloaded webwiz forum SQL server database 5. added new 20 users or posts/topics 6. PLEASE CONFIRM: if i import the previous webwiz forum access database to my new webwiz forum SQL database will the data be overwritten? or will the data just be added? will the result be 70+ users or posts/topics?? Thanks! Ann |
Replies:
Posted By: grovelli
Date Posted: 15 September 2008 at 8:34pm
| Hi, what page did you download webwiz forum Access database from? |
Posted By: WebWiz-Bruce
Date Posted: 16 September 2008 at 8:51am
|
The Access database is available in the Access download of Web Wiz Forums. However, the user above is incorrect in how you move from Access to SQL Server. To move from Access to SQL Server you need to use the Upsize wizard found in MS Access to upsize the Access database to SQL Server. You also need to have SQL Server installed on the local network to do this (the free Express Edition is good for this). Then when you upsize the database choose to have Access create a new database when upsizing. Once the database is upsize if you need to move the SQL Server database to that of your web host you should create a backup of the database (.bak file) then use this to restore the database on your web hosts server. If you try to export/import the data you often loose important parts of the database schema, so you should use the database backup method to move your database. ------------- 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: grovelli
Date Posted: 16 September 2008 at 9:30am
|
Hi Bruce,
SSMA for Access: Frequently Asked Questions says, "SSMA for Access offers a richer set of features, such as network scanning, conversion assessment reports, and more. SSMA for Access also fixes many issues currently not handled correctly by the Office Upsizing Wizard."
So I guess you get more bang for your buck if you use that instead.
I'm looking at http://forums.webwiz.net/ - http://forums.webwiz.net/ but I don't see an "Access download" section
 |
Posted By: WebWiz-Bruce
Date Posted: 16 September 2008 at 10:33am
|
Have done hundreds of upsizes of Web Wiz Forums Access to SQL Server for people moving their Web Wiz Forums Access versions across to our hosted solutions and never had an issue with the Access 2007 upsize wizard. Not used the other software you mention so would not like to comment. The various different database versions are available on the Web Wiz Forums download page at http://www.webwizforums.com - www.webwizforums.com ------------- 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: grovelli
Date Posted: 16 September 2008 at 10:41am
|
Thank you Bruce I'm using Access 2003 so evidently the 2007 Upsizing wizard is more performant.
SSMA is from Microsoft still: http://www.microsoft.com/sql/solutions/migration/access/ssma_access_faq.mspx - http://www.microsoft.com/sql/solutions/migration/access/ssma_access_faq.mspx
|
Posted By: fabrixnet
Date Posted: 30 September 2008 at 11:06am
|
hallo, is possible Upgrade Web Wiz Forums with access version 7 to version 9 with mysql? Which Tool I must use? Web Wiz Forums version 8.x Upgrade Tools: Microsoft SQL Server Upgrade Tool mySQL Upgrade Tool Microsoft Access Upgrade Tool Web Wiz Forums version 7.x Upgrade Tools: Microsoft SQL Server Upgrade Tool Microsoft Access Upgrade Tool |
Posted By: WebWiz-Bruce
Date Posted: 30 September 2008 at 12:01pm
|
SQL Server and Access use a relational database for Web Wiz Forums. mySQL is not a relational database. This means that mySQL version of Web Wiz Forums uses a very different none relational database schema compared to the SQL Server and Access versions so you can not move from Access or SQL Server to mySQL. ------------- 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: mbd2
Date Posted: 17 October 2008 at 11:31pm
|
Bruce I'm trying to migrate from Access to sql. Every time I do an Upsizer it say Skipped or Failed. I'm using Access 2007 trying to upload to SQL 2000 Server. Any pointer you can give me would be grateful. Thanks Dale ------------- Balloon Entertainment at it's best! http://www.mbd2.com" rel="nofollow - www.mbd2.com -- http://www.mbd2.com/tradeshow/promodvd.html" rel="nofollow - Trade Show Presenter - video |