Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Upgrade problem
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Upgrade problem

 Post Reply Post Reply
Author
msnahm View Drop Down
Groupie
Groupie


Joined: 27 January 2009
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote msnahm Quote  Post ReplyReply Direct Link To This Post Topic: Upgrade problem
    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?


Edited by msnahm - 01 August 2010 at 6:05am
Back to Top
msnahm View Drop Down
Groupie
Groupie


Joined: 27 January 2009
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote msnahm Quote  Post ReplyReply Direct Link To This Post Posted: 01 August 2010 at 6:07am
Please S.O.S ... Cry
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
msnahm View Drop Down
Groupie
Groupie


Joined: 27 January 2009
Status: Offline
Points: 41
Post Options Post Options   Thanks (0) Thanks(0)   Quote msnahm Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.