Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - update 7.92 to SQL 2005 and 8.01
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

update 7.92 to SQL 2005 and 8.01
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
chong67 View Drop Down
Groupie
Groupie


Joined: 15 November 2004
Location: United States
Status: Offline
Points: 46 		Post Options Post Options   Thanks (0) Thanks(0)   Quote chong67 Quote  Post ReplyReply Direct Link To This Post Topic: update 7.92 to SQL 2005 and 8.01
    Posted: 22 May 2006 at 9:04pm
I am currently running WWF 7.92 on SQL 2000.
 
I want to run it on SQL 2005.
 
1.  Will it run just like that if I have a backup of this db on SQL2000 and port it to 2005?
 
2.  I want to run WWF 8.01 on it also.
 
3.  What should I do first?
 
I am new to SQL2005.
 
thanks for any help I can get!  LOL
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: 23 May 2006 at 8:50am
You can just use the import/export DTS tools in SQL Server Management console to move the database straight from SQL Server 2000 to the 2005 version. You don't need to make any other changes. Except maybe update the database connection details in the forum.

You can update your forum to version 8.01 either before or after you move the database to 2005, it makes no difference in this case.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
wistex View Drop Down
Mod Builder Group
Mod Builder Group


Joined: 30 August 2003
Location: United States
Status: Offline
Points: 877 		Post Options Post Options   Thanks (0) Thanks(0)   Quote wistex Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2006 at 6:05pm
We are going to be doing the same thing.
 
Do you see any problems if we use the Backup and Restore method to transfer the data (i.e. backup from SQL 2000 and restore to SQL 2005 Express)?  We have no access to the DTS.
 
Thanks.
WisTex Solutions
CaribbeanChoice Forums
Back to Top
SUJO View Drop Down
Newbie
Newbie


Joined: 25 July 2005
Location: Slovenia
Status: Offline
Points: 26 		Post Options Post Options   Thanks (0) Thanks(0)   Quote SUJO Quote  Post ReplyReply Direct Link To This Post Posted: 24 May 2006 at 6:45pm

I have made many moving and importing and reimporting and backing up my portal db (based on wwf)... from and to SQL2005 and SQL2000... more or less everything was doing well... the transfers (where you must be cautious at import settings otherwise it is not working), the backups, the upsizing... the works - the only thing that I have to add from personal experience (which is quite extensive) - BE CAUTIOUS with those settings. If you are, you have "almost" nothing to worry about...

Oh - and a note for SQL2005 users from up-sizing - the db is NOT (at least mine was not) fully optimized for the new system - it tends to get slower on SQL2005 then SQL2000 - that IS a fact from many testings hours...


Edited by SUJO - 24 May 2006 at 6:47pm
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.