Moving database from SQL Server 2000 to MS SQL 2005 Exrpess

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jamrock - 24 Jul 2008 14:51 GMT

Is it possible to move a database from SQL Server 2000 Standard to SQL
Server 2005 Express?

We have a 3 GB database with some historical information that we need to
access from time to time.

Reply to this Message

Olaf Pietsch - 24 Jul 2008 15:21 GMT

> Is it possible to move a database from SQL Server 2000 Standard to SQL
> Server 2005 Express?
>
> We have a 3 GB database with some historical information that we need to
> access from time to time.

yes, via backup old system and restore at new system or via detach attach

after restore or attach I recommend to use dbcc checkdb and dbcc
updateusage.
http://msdn.microsoft.com/en-us/library/ms188796.aspx

Signature

Gruß Olaf
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Blog (http://www.sqlpass.de/PASSUserBlogs/tabid/178/Default.aspx?BlogID=3)
Regionalgruppe Köln/Bonn/Düsseldorf
(http://www.sqlpass.de/Regionalgruppen/KoelnBonnDuesseldorf/tabid/81/Default.aspx)

Reply to this Message

vinu - 24 Jul 2008 15:36 GMT

to add toOlaf's post , if it is detach/attach method then set the database
compatibility to 90

Signature

vinu
http://oneplace4sql.blogspot.com/

>> Is it possible to move a database from SQL Server 2000 Standard to SQL
>> Server 2005 Express?
[quoted text clipped - 7 lines]
> updateusage.
> http://msdn.microsoft.com/en-us/library/ms188796.aspx

Reply to this Message

jamrock - 24 Jul 2008 18:45 GMT

Thanks for the answers.

I was under the impression that only MSDE could be moved to SQL Server 2005
Express.

I thought that SQL Server 2000 Standard had to be moved to SQL Server 2005
Standard or higher.

> to add toOlaf's post , if it is detach/attach method then set the
> database compatibility to 90
[quoted text clipped - 10 lines]
>> updateusage.
>> http://msdn.microsoft.com/en-us/library/ms188796.aspx

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 24 Jul 2008 18:50 GMT

A database does not care what edition it is on, unless you are using
features that do not work in the target edition. Even in that case though
it can be a relatively harmless (or at least non-blocking) problem, for
example you can create a database with an indexed view in enterprise, back
it up, and restore it on express. The behavior (if you do not use the
NOEXPAND hint) will change, but you will still be able to use the database.

On 7/24/08 1:45 PM, in article e10IOUb7IHA.3736@TK2MSFTNGP06.phx.gbl,

> Thanks for the answers.
>
[quoted text clipped - 18 lines]
>>> updateusage.
>>> http://msdn.microsoft.com/en-us/library/ms188796.aspx

Reply to this Message