Backup/restore should work fine--I've done it several times.
Just remember, after the restore, to hit the database properties and change it to run in compat level 90 (if you want SQL Server 2005 native compatibility), as it will default to 80. On 2/24/07, Efran Cobisi <[EMAIL PROTECTED]> wrote:
Hello Shawn! You are right, attach/detach should do the trick, even if with some pain, expecially for replicated db... [1]. I would, however, stay with Copy Database Wizard; I think it would do a better job in reporting eventual incompatibilties during the upgrade (copy) phase. HTH, Efran Cobisi http://www.cobisi.com Shawn Wildermuth (MVP) wrote: > 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(r) http://www.develop.com > > View archives and manage your subscription(s) at http://discuss.develop.com > =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
-- Eric Means [EMAIL PROTECTED] http://www.randomtree.org/eric/ =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
