If you detach from 2000, and attach to 2005, it will upgrade it. Only caveat there is that once you attach it to 2005 (even if you leave it at 2000 compatibility), you can *never* reattach it to 2000...so make backups!
Thanks, Shawn Wildermuth http://adoguy.com http://wildermuthconsulting.com Microsoft MVP (C#), MCSD.NET, Author and Speaker -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Efran Cobisi Sent: Saturday, February 24, 2007 6:42 AM To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM Subject: Re: [ADVANCED-DOTNET] Importing SQL 2000 Database into SQL 2005 Hello Jon, If you have to just upgrade a *database *to the newer version, I recommend you to use the Copy Database Wizard [1], available in SSMS. If you have to upgrade a SQL Server 2000 *istance *to SQL Server 2005, you could make an in-place upgrade [2]. Afaik SQL Server 2005 database backup format is incompatible with previous versions, so backup/restore shouldn't work for you. Attaching and detaching the database files shouldn't work too. [1] http://msdn2.microsoft.com/en-us/library/ms188664.aspx [2] http://www.sqlservercentral.com/columnists/rpearl/installingandupgradingtosq lserver2005.asp HTH, Efran Cobisi http://www.cobisi.com Jon Rothlander wrote: > I'm trying to import my SQL 2000 database into 2005. How do you do this? I > cannot find any documentation on this and it doesn't look to be a simple > matter of creating and restoring a backup. There must be more to it but I > cannot find anything on the Internet in regards to how to upgrade. > > Any suggestions? References? > > Best regards, > Jon Rothlander > > =================================== > This list is hosted by DevelopMentorR http://www.develop.com > > View archives and manage your subscription(s) at http://discuss.develop.com > =================================== This list is hosted by DevelopMentorR http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
