Developer to Standard

We just finished development of a set of databases with Dev Edition and want
to move them into production. We'd like to use the same machine for the
production databases. We'd also like to uninstall Dev Edition and install
Standard.
What is the best way to move all of the databases from the old (Dev)
instance to the new (Standard) instance. We're not using any of the
'features' unique to Dev/Enterprise. Pretty basic stuff.
Thanks.
--
Mike MurphyI would do a sp_detach_db to unattach your database (or you can do the same
for Enterprise Manager). Uninstall dev. Install Standard. Then do an
sp_attach_db (or the same from Enterprise Manager) to attach your database
files back to SQL Server.
"Mike Murphy" wrote:
> We just finished development of a set of databases with Dev Edition and want
> to move them into production. We'd like to use the same machine for the
> production databases. We'd also like to uninstall Dev Edition and install
> Standard.
> What is the best way to move all of the databases from the old (Dev)
> instance to the new (Standard) instance. We're not using any of the
> 'features' unique to Dev/Enterprise. Pretty basic stuff.
> Thanks.
> --
> Mike Murphy|||Before you do anything to your configuration, get a good backup. Then you
can uninstall Dev, install standard and either restore from backup or
sp_attachdb to re-attach your database files.
But get that backup first.
"Mike Murphy" <MikeMurphy@.discussions.microsoft.com> wrote in message
news:9AD45589-7D05-4B5A-88BB-DE850C577F94@.microsoft.com...
> We just finished development of a set of databases with Dev Edition and
> want
> to move them into production. We'd like to use the same machine for the
> production databases. We'd also like to uninstall Dev Edition and install
> Standard.
> What is the best way to move all of the databases from the old (Dev)
> instance to the new (Standard) instance. We're not using any of the
> 'features' unique to Dev/Enterprise. Pretty basic stuff.
> Thanks.
> --
> Mike Murphy|||Won't you want both development and live environments once you go into
production?
One point in addition to the other responses. Dev Ed is equivalent to
Enterprise Ed not Standard. As the feature set is slightly different I
suggest you test on a Standard Ed installation before you go into
production. Of course that should happen anyway. Never test only in the Dev
environment.
--
David Portas
SQL Server MVP
--