Can Sql Server Express 2005 Run a Sql Server 2000 database?

Should be a quick question:

I've got a client with a Sql Server 2000 database. He wants to hook it up to a server that is only running Sql Server Express 2005. Can this work?

Thanks!

Tell him to Backup the database and send you the .bak you can restore it as 2005 database. I have posted a FAQ about moving SQL Server databases and there is a free chapter about Backup and Restore in the link below. Hope this helps.

http://forums.asp.net/thread/1454694.aspx

|||

Thanks! I will recommend this to my client.

For argument's sake though; could a 2000 database run in 2005 w/out any changes?

|||Yes you could run it without changes if needed it will be related to stored proc rewrites and if it comes with Text columns you may want to change to Varchar(Max) it let you run text like in row data. And if there are indexes drop them and create new one. Hope this helps.|||

Before you start backup - restore check if he is not using features which are not available on SQL Express like SQL Agent for example?

Thanks