Re: [ADVANCED-DOTNET] Importing SQL 2000 Database into SQL 2005

2007-02-24 Thread Eric Means
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

Re: [ADVANCED-DOTNET] Importing SQL 2000 Database into SQL 2005

2007-02-24 Thread Efran Cobisi
@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

Re: [ADVANCED-DOTNET] Importing SQL 2000 Database into SQL 2005

2007-02-24 Thread Shawn Wildermuth (MVP)
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

Re: [ADVANCED-DOTNET] Importing SQL 2000 Database into SQL 2005

2007-02-24 Thread Efran Cobisi
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 fo