Convert SQL 2005 to MSDE

Is there any way to convert a SQL Server 2005 (v9) database to a MSDE (v8)
database?
No, Once you upgrade or create a V9 database you can't convert to/back to a v8.
Adam J Warne, MCDBA
"Joe Pannone" wrote:

> Is there any way to convert a SQL Server 2005 (v9) database to a MSDE (v8)
> database?
|||You have to export all the data and re-import it back into a MSDE database.
Of course any 2005 specific features or datatypes will be an issue.
Andrew J. Kelly SQL MVP
"Joe Pannone" <JoePannone@.discussions.microsoft.com> wrote in message
news:CE10B408-73C3-497E-9309-85EC2D8AFDB1@.microsoft.com...
> Is there any way to convert a SQL Server 2005 (v9) database to a MSDE (v8)
> database?
|||Once you've upgraded the DB to SQL 2005, is it possible to use Express
Edition in place of MSDE?
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.