Moving the SQL 2000 database to 2008

Hi David, As you know i posted a response to this question via a ticket. For the benefit of others...

Hope your very well. I'm sorry for my delay responding.

We've rectally been undergoing a similar transition (from SQL 2005 / 2008 to 2008 R2). The good news is it's fairly straight-forward. You should just be able to take a .bak of your SQL 2000 database and restore this in SQL Server 2008 R2. Then update the connection string to point to your restored 2008 R2 database.

Depending on permissions you may need to add a SQL Server account matching your older 2000 database account you used to ensure the object owners are not effected. This may not be required if all objects are owned by dbo.

Of course once you move to 2008 R2 you can't go back. You can't for example restore an R2 backup on a standard 2008 SQL Server.

You can install 2008 R2 alongside your existing 2008 instance as a separate named instance. As many core elements are still shared between 2008 and 2008 R2 it will only install the R2 server (no need for separate SSMS installation etc)

I hope this helps a little David. If i can assist further please don't hesitate to respond. We are in BETA with IF.NET 2012 which has delayed me a little here. Final release should be early December :)

If i can assist further please don't hesitate tor respond.

Kindest Regards,

Ryan Healey
Founder and CTO

http://community.instantasp.co.uk/Uploads/Images/7e043dc3-463f-4f68-8ee0-f237.gif

Facebook | Twitter | Blog | Docs
12 tips to improve your customer support

Author	Message
dstoltz	Posted 18/11/2011 18:37:13
If I only had a Life Group: Customers Last Active: 28/11/2011 12:32:56 Posts: 91, Visits: 3,345 406	Hi All, Our current forum is running on a SQL 2000 database. I am planning on moving it to a SQL 2008R2 instance. How should I plan this? Is it as easy as updating the connection string and it's done? Thanks for any info.
	REPLY QUOTE
*Eddy Lucast*	Posted 25/11/2011 16:03:57
If I only had a Life Group: Moderators Last Active: 2 days ago @ 17:04:28 Posts: 67, Visits: 1,093 427	Sounds like you've got it down. This is something I've done. When my database was imported into SQL2008 it recognised it was a SQL 2000 database and made all the necessary changes to the database. I was surprised how easy it was.
	REPLY QUOTE
Ryan Healey	Posted 25/11/2011 16:27:26
I dont see much sun Group: Administrators Last Active: Yesterday @ 13:22:53 Posts: 2,339, Visits: 22,736 7,714	Hi David, As you know i posted a response to this question via a ticket. For the benefit of others... Hope your very well. I'm sorry for my delay responding. We've rectally been undergoing a similar transition (from SQL 2005 / 2008 to 2008 R2). The good news is it's fairly straight-forward. You should just be able to take a .bak of your SQL 2000 database and restore this in SQL Server 2008 R2. Then update the connection string to point to your restored 2008 R2 database. Depending on permissions you may need to add a SQL Server account matching your older 2000 database account you used to ensure the object owners are not effected. This may not be required if all objects are owned by dbo. Of course once you move to 2008 R2 you can't go back. You can't for example restore an R2 backup on a standard 2008 SQL Server. You can install 2008 R2 alongside your existing 2008 instance as a separate named instance. As many core elements are still shared between 2008 and 2008 R2 it will only install the R2 server (no need for separate SSMS installation etc) I hope this helps a little David. If i can assist further please don't hesitate to respond. We are in BETA with IF.NET 2012 which has delayed me a little here. Final release should be early December :) If i can assist further please don't hesitate tor respond. Kindest Regards, Ryan Healey Founder and CTO Facebook \| Twitter \| Blog \| Docs 12 tips to improve your customer support
	REPLY QUOTE
dstoltz	Posted 28/11/2011 12:39:42
If I only had a Life Group: Customers Last Active: 28/11/2011 12:32:56 Posts: 91, Visits: 3,345 406	Thanks Ryan for the info...I plan on doing this upgrade tomorrow morning... I figured it would be pretty easy, but wanted to check...I think the only issues I may have to tweak would have to do with full text searching, etc... I'll keep you posted and let you know how it goes. Thanks! Dave
	REPLY QUOTE
soniceffect	Posted 17/12/2011 19:15:49
InstantASP Veteran Group: Customers Last Active: 18/04/2012 10:22:39 Posts: 14, Visits: 200 61	Ryan Healey (25/11/2011) You should just be able to take a .bak of your SQL 2000 database and restore this in SQL Server 2008 R2. Then update the connection string to point to your restored 2008 R2 database. Just to add to this, depending on your server access, you could even just detach from your 2000 instance and reattach to your R2 instance.
	REPLY QUOTE

Peer to peer support & product discussion

Moving the SQL 2000 database to 2008

Moving the SQL 2000 database to 2008

Similar Topics

Reading This Topic