How to Move a database in SQL 2000 to 2005 ?

nnraja · #1 (**permalink**) 10-24-2007, 10:45 AM

Hi all,

How do I take a database developed and operating and get into the 2005 SQL Server?

arjkhanna · #2 (**permalink**) 10-26-2007, 05:05 AM

Hi nnraja,

You can either do

(a) BACKUP and RESTORE

(2) Detach, Move (or Copy) and then ATTACH

(iii) Script out the database, and the data, and execute the scripts.

And there are a few other options. If there is something specific about your situation where one of these options

There are 3 options for you,

1. Backup and Restore database

2. Detach and Attach database

3. Copy database wizard (requires the sql 2005 which is the destination to have SP2)

If you can afford downtime you can chose the 2nd option else you are left with 1 or 3.

satheesh · #3 (**permalink**) 10-29-2007, 01:08 AM

Hi all,

When you do go through the above proess you database will generally still be running in sql 2000 compatibility mode, under the database options you can change you database options so that the database will run using the sql 2005 engine

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
server move	Booom	Discussweb HQ	1	02-10-2008 02:58 AM
Move an image within a picture box in C#	$enthil	C# Programming	4	01-18-2008 11:42 PM
Sql server 2005 Database Maintenance	arjkhanna	Server Management	3	10-30-2007 11:11 AM
SQL Server 2000 to 2005	S.Vinothkumar	Database Support	3	09-27-2007 04:22 AM
I Cannot access SQL 2005 integrated services after installing SQL-2005..?	theone	Database Support	1	07-27-2007 01:12 AM