Monday, March 19, 2012

Changing sql enterprise to sql standard edition.

Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!You can attach databases from EE to SE (in fact, you can attach across all e
ditions).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"MariaGuzman" <marisa@.devdex.com> wrote in message news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gb
l...
> Hi, now we have a server that is running in sql server2000 enterprise
> edition. For licenses problems we need to desinstall this edition and
> install the standard edition.
> Do somebody know if there is a problem in attach the databases that were
> created in the enterprise edition on the new standard edition server'
> What do you recommend to me to do this migration?
> Thanks a lot for your help!!!
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||> You can attach databases from EE to SE (in fact, you can attach across all
editions).
Well, except a > 2GB database to MSDE... :-)|||Good point, Aaron. :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:ejmYeIbHFHA.2456@.TK2MSFTNGP09.phx.gbl...
> editions).
> Well, except a > 2GB database to MSDE... :-)
>|||Functionaly, the database should be equivalent. Unless you were doing
esoteric Distributed Partitioned Views or some such, you should run into any
problems.
Take a look at the product features of both editions to see if any of these
match thing you've been doing.
Also consider that if you had purchased Developer Edition to build your
systems, you would have been using Enterprise Edition and it would have been
likely that many users have deployed such systems to production level
Standard Edition. The only difference between DE and EE is the EULA.
Sincerely,
Anthony Thomas
"MariaGuzman" <marisa@.devdex.com> wrote in message
news:uet9BdaHFHA.3376@.TK2MSFTNGP14.phx.gbl...
Hi, now we have a server that is running in sql server2000 enterprise
edition. For licenses problems we need to desinstall this edition and
install the standard edition.
Do somebody know if there is a problem in attach the databases that were
created in the enterprise edition on the new standard edition server'
What do you recommend to me to do this migration?
Thanks a lot for your help!!!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment