Can I work with abril ctp and migrate later to an express version?

Hello

The final customers of my application should have sql server express. Can I work with sql abril ctp and then when the final version of sql express has been released install it and migrate the database?

You should use June CTP (build 1187), not April CTP.

June CTP to RTM (Release) migration is a supported scenario. However, since you will be downgrading the SKU (e.g. Developer SKU to Express SKU) certain features may/will be unavailable. Some of this is transparent to the app (e.g. you won't get AWE support), but some may impact functionality (e.g. feature functionality is limited). It depends on what your application uses.

If you are concerned about databases only, upgrade should work fine from June CTP.

Regards,
Boris.

|||The only thing I need to create is tables, views, triggers and CLR stored procedures. So If I create these objects with sql 2005 june ctp and visual studio 2005 june ctp.

And when the final version of sql express and vs 2005 had been released it should work? I guess i only have to make a backup of the sql june ctp database, uninstall june ctp, uninstall vs 2005 june ctp, and then install vs 2005 profesional or team system , and then install final version of sql express and restore the database and it should work?

Am I missing something?|||

Yes, what you describe should work.

There are two parts to your question:

1. Going from June CTP to RTM – this should be just fine
2. Going from Developer SKU to Express SKU – this has caveats as outlined below

Caveat: if you use a feature that is available only on Dev/Enterprise SKU, once you migrate to Express you may run into problems. Most notable features that may create problems are database mirroring, database snapshot, failover clustering and table partitioning.

At release time there will be a document describing upgrade/downgrade process.

HTH,
Boris.