express to enterprise edition

Hi All

I have sql 2005 express on my Dev machine but am planning on using a full sql 2005 database where i deploy my program and i have 2 questins please

1. Will my sql express database work with the full version of SQL 2005 or do i import it or something ( DB will get bigger than sql express max at some point)and

2. I was intending using stored procedures, can these also be easily be used/ transfered on am SQL 2005 database

thanks

Gibbo

hi Gibbo,

gibbo1715 wrote:

I have sql 2005 express on my Dev machine but am planning on using a full sql 2005 database where i deploy my program and i have 2 questins please

1. Will my sql express database work with the full version of SQL 2005 or do i import it or something ( DB will get bigger than sql express max at some point)and

yes.. SQLExpress is, somehow, a "subset" of the "full" SQL Server editions, so anything that works on Express works on the full editions as well but User Instances, that are supported on SQLExpress only..

2. I was intending using stored procedures, can these also be easily be used/ transfered on am SQL 2005 database

yes, no problem at all as, again, all the internal structures of database files are the same..

regards