Web Wiz Forums - Content migration

Print Page | Close Window

Content migration

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

Topic: Content migration

Posted By: yandr
Subject: Content migration
Date Posted: 19 March 2009 at 12:43pm

Do you have any adviceon migrating the content from an Access database to SQL server and vice versa? An automated import tool would be nice.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 March 2009 at 1:34pm

Microsoft have tools for doing this.

There is the Upsize Wizard built into Access or you can use the Microsoft SQL Server Migration Assistant.

However both will create extra timestamp fields that need to be removed, amd yje Migration Assistant will create extra constants that also need to be removed after the migration is complete.

You should also run the database optimisation tool as well on the migrated SQL Server database which will be available from the web wiz forums download page leter today.

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