Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Moving Whole Forum to new Host
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Moving Whole Forum to new Host
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Topic: Moving Whole Forum to new Host
    Posted: 04 December 2008 at 3:02pm
Hi Bruce and all...
 
I know I haven't posted in a while though I read every day. I have a question that has been bugging me and some others I know for a while.
 
I have tried to backup and reinstall the forum database using MS DTS (SQL Data Transformation Service)  many times and it always fails on the indexes. I'm not sure if anyone has found a work around for this and thought I would raise the question.
 
BUT
 
My main question is, has anyone found a way to move a forum database from one SQL server to another without errors? Basically, I am consolidating my hosting accounts to a dedicated environment and I would really like to move the forums, data, posts and members transparently. If there is a solution such as this, it could also be used to "mirror" the data on a local server which is an issue I have been unable to resolve.
 
Anyone have any ideas???
“If you want things to be different, you must be willing to do different things!”David Francis
Back to Top
Putz22 View Drop Down
Moderator Group
Moderator Group


Joined: 06 May 2008
Location: United States
Status: Offline
Points: 182 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Putz22 Quote  Post ReplyReply Direct Link To This Post Posted: 04 December 2008 at 3:17pm
Have you tried the import tools for the DataBase?  I have not had a problem with it... as always I know you have made a backup... try to make a backup without running any other programs..  as you make that Backup of the Data Base you should be able to you the import tool to keep all the database in tact..
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: 05 December 2008 at 1:29pm
To move the SQL Server database to a new server keeping the schema intact you can either:-

1. Make a full backup of the database (a .bak file) then restore the database on a the new server

2. Detach the database from SQL Server then move the .mdf and .ldf files to the new SQL Server where you reattach the database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
dfrancis View Drop Down
Senior Member
Senior Member


Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dfrancis Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2008 at 3:50pm
perfect... thanks
“If you want things to be different, you must be willing to do different things!”David Francis
Back to Top
billd3 View Drop Down
Senior Member
Senior Member


Joined: 19 February 2003
Location: United States
Status: Offline
Points: 530 		Post Options Post Options   Thanks (0) Thanks(0)   Quote billd3 Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2008 at 8:01pm
OR, purchase webwiz hosting, give them the admin id and password for the current/old SQL setup, and buy Bruce a beer and they will move it.
Our forum was moved over seamlessly in minutes, thanks to the crew at webwiz hosting!
BillD
http://theamcpages.com
http://theamcforum.com
Back to Top
elaen View Drop Down
Newbie
Newbie


Joined: 12 February 2009
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote elaen Quote  Post ReplyReply Direct Link To This Post Posted: 12 February 2009 at 6:29am
it is the first time that i come here,yeah......
Back to Top
Lynford View Drop Down
Groupie
Groupie


Joined: 14 December 2004
Status: Offline
Points: 171 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Lynford Quote  Post ReplyReply Direct Link To This Post Posted: 13 February 2009 at 2:50pm
Originally posted by billd3 billd3 wrote:

OR, purchase webwiz hosting, give them the admin id and password for the current/old SQL setup, and buy Bruce a beer and they will move it.
Our forum was moved over seamlessly in minutes, thanks to the crew at webwiz hosting!


Same as that - Superb service.

Had crappy old Access upgraded to SQL and an old version of WWF upgraded to the latest version at the same time.
Great value for money & Service Clap
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.