Moving SQL Express data to SQL Server 2005 Dev?

Hi gang,
Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
guy who's been tasked with moving an web app developed with SQL
Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
having literally NO working experience with the Microsoft products, am
wondering how one would migrate data from SQL Express to SQL Server
proper...
Any help or advice in this matter is most appreciated, I've trolled
this group but found no concrete info. Reading the documentation is
says it can be done at time of install, but, given my apprehension of
MS products reliability, is this a safe way to move a mission critical
DB?
Thanks a million,
Cheers
- Randall"MSSQL-n00b" <spliffhuxtable@.gmail.com> wrote in message
news:1174576289.977944.137500@.b75g2000hsg.googlegroups.com...
> Hi gang,
> Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
> guy who's been tasked with moving an web app developed with SQL
> Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
> having literally NO working experience with the Microsoft products, am
> wondering how one would migrate data from SQL Express to SQL Server
> proper...
> Any help or advice in this matter is most appreciated, I've trolled
> this group but found no concrete info. Reading the documentation is
> says it can be done at time of install, but, given my apprehension of
> MS products reliability, is this a safe way to move a mission critical
> DB?
> Thanks a million,
>
SQL Server Express uses the same engine and has the same file format as the
other editions of SQL Server. So you can take a backup of the database from
Express and restore it on another edition, you can detach the database and
attach it on another edition, or you can upgrade the Express edition to a
higher edition.
David