March 10, 2005 at 3:57 pm
Our server now has MSDN installed with a small SQL database.
We have purchased a full version of SQL to replace the MSDN version for other databases.
I understand this full version has additional capabilities compared to the MSDN version.
Would it be safe to say that I could backup existing database, uninstall and reinstall SQL with the full version, and then restore that database?
What are the warnings or gotchas to removing one version of SQL with the new one? Could I simply reinstall over the top of the existing one?
Hopefully this is easy to answer.
Thanks!
March 10, 2005 at 4:12 pm
MSDN (Microsoft Developers' Network) or MSDE (Microsoft Data Engine) or Developer's Edition?
In any event, you won't have any trouble migrating from one to the other. A backup and restore should be fine. Only gotchas are- if you have DTS packages, you'll want to either backup msdb and restore it as well, or save the packages to a structured storage file and then bring them back in, and your SQL logins will be orphaned and will need to be synched back with sp_change_users_login. Another method would be to simply detach the databases, uninstall, install your new version, then reattach the databases.
Steve
March 11, 2005 at 8:04 am
Don't forget your server logins:
http://support.microsoft.com/default.aspx?kbid=246133
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply