Move DB from Sql Server 2000 to Sql Server 2005

Hi;
How can I move a database from Sql Server 2000 to Sql Server 2005 (different
machines, same domain)?
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htmDavid Thielen wrote:
> Hi;
> How can I move a database from Sql Server 2000 to Sql Server 2005 (different
> machines, same domain)?
> --
> thanks - dave
> david_at_windward_dot_net
> http://www.windwardreports.com
> Cubicle Wars - http://www.windwardreports.com/film.htm
You can do a backup/restore or detach/attach , both the same as you
would going from sql 2000 to another sql 2000 server.|||Hi,
Add on to that;
1. You can use Copy database wizard to copy database online (no downtime)
See the below article upgrade databases from SQl 2000 to sql 2005.
http://msdn2.microsoft.com/en-us/library/ms188664.aspx
Thanks
Hari
SQL Server MVP
"Ken" <kshapley@.sbcglobal.net> wrote in message
news:1155595027.838838.10620@.h48g2000cwc.googlegroups.com...
> David Thielen wrote:
>> Hi;
>> How can I move a database from Sql Server 2000 to Sql Server 2005
>> (different
>> machines, same domain)?
>> --
>> thanks - dave
>> david_at_windward_dot_net
>> http://www.windwardreports.com
>> Cubicle Wars - http://www.windwardreports.com/film.htm
> You can do a backup/restore or detach/attach , both the same as you
> would going from sql 2000 to another sql 2000 server.
>|||Hi Dave,
Thanks for posting.
My understanding of your issue is: You want to move database from SQL 2000
to SQL 2005.
Ken & Hari provided great suggestions. Summary as:
1. Backup/Restore
2. Detach/Attach
3. Use Copy Database Wizard in SQL 2005.
These suggestions are accurate and I'd like to provide some additional
information as below:
How to: Move a Database Using Detach and Attach
http://msdn2.microsoft.com/en-us/library/ms187858.aspx
How to: Upgrade a Database Using Detach and Attach
http://msdn2.microsoft.com/en-us/library/ms189625.aspx
How to: Upgrade to SQL Server 2005 with the Copy Database Wizard
http://msdn2.microsoft.com/en-us/library/ms190775.aspx
In addition, please don't forget to transfer the login if necessary.
Please refer to following article:
246133 How to transfer logins and passwords between instances of
SQL Server
http://support.microsoft.com/default.aspx?scid=kb;EN-US;246133
Hope the information helps. If you have any other concerns or questions,
please feel free to let me know. I'm glad to provide assistance.
Best regards,
Vincent Xu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
>>Thread-Topic: Move DB from Sql Server 2000 to Sql Server 2005
>>thread-index: Aca/74Gu4a9R8Y7PR6m3MIFjbCbRow==>>X-WBNR-Posting-Host: 69.25.210.130
>>From: =?Utf-8?B?RGF2aWQgVGhpZWxlbg==?= <thielen@.nospam.nospam>
>>Subject: Move DB from Sql Server 2000 to Sql Server 2005
>>Date: Mon, 14 Aug 2006 15:18:02 -0700
>>Lines: 13
>>Message-ID: <41275E10-6591-43F1-9C82-CA1C2FC0F131@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:441928
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi;
>>How can I move a database from Sql Server 2000 to Sql Server 2005
(different
>>machines, same domain)?
>>--
>>thanks - dave
>>david_at_windward_dot_net
>>http://www.windwardreports.com
>>Cubicle Wars - http://www.windwardreports.com/film.htm
>>