From: bcap on
Hi,

Is there any challenges to converting a SQL Server 2005 to SQL Express
2008? If I used a BAK of a 2005 DB, can I restore it onto SQL Express
2008 similiar to the way SQL Server 2005 works without any problems?
From: TheSQLGuru on
You may upgrade this way. As for problems, there are things that are
different between 2005 and 2008. You need to do an analysis to determine
what if anything you may need to change.

There is an upgrade advisor from microsoft - download and use it.

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"bcap" <rayh(a)patriots.com> wrote in message
news:97e43b17-d8f1-450b-96bf-6620a277932b(a)e6g2000yqh.googlegroups.com...
> Hi,
>
> Is there any challenges to converting a SQL Server 2005 to SQL Express
> 2008? If I used a BAK of a 2005 DB, can I restore it onto SQL Express
> 2008 similiar to the way SQL Server 2005 works without any problems?