Web Wiz Forums - Upgrade problem

Print Page | Close Window

Upgrade problem

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

Topic: Upgrade problem

Posted By: msnahm
Subject: Upgrade problem
Date Posted: 31 July 2010 at 2:22pm

My old WWF is version 9.54 in MS SQL 2000, Now I want to change my host to new another host with upgrading to Version 9.69 with MS SQL 2005.

I do not have any back up from old version on my PC so I can not restore my data from old DB to new DB. I used Import/Export tools in "MS SQL Management Studio 2005" as following:

I created new DB structure and tables in MS SQL 2005 version.
I exported all data from old DB to New DB successfully.
I setup WWF Version 9.69 wizard and chose Upgrade options to MS SQL 2005/2008.
All previous steps is ok and without error, but after browsing the Forum Homepage, the list of forums and forum topics did not appear to me correctly. Some topics has been assigned to another forum, some forum has been lost and ...

Do you have any suggestion for resolving the problem?

Replies:

Posted By: msnahm
Date Posted: 01 August 2010 at 6:07am

Please S.O.S ... Cry

Posted By: WebWiz-Bruce
Date Posted: 02 August 2010 at 9:16am

The Import/Export Tools in MS SQL Management Studio are totally useless as they drop allot of the database schema such as default values, primary keys, ralationships, etc.

What you would need to do is get a back of your SQL Server database (.bak file), which can then be used to restore the database on your new host.

Most good web hosts will give you tools to create backups of your SQL Server databases and restore them, but if they do not then you will need to contact the hosting companies to get them to help with this.

-------------
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: msnahm
Date Posted: 09 August 2010 at 7:20am

I resolve my problem, I guessed it can be useful for others.

There is a tools in Microsoft website for creating a backup from MS SQL Data and Structure. this tools is "Database Publishing Wizard" that creates a script from all database data and structure.

Regards