|
Home > Archive > MS SQL Server > March 2006 > Upgrading SQL 2005 Evaluation Edition
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Upgrading SQL 2005 Evaluation Edition
|
|
| Andre S 2006-03-25, 9:23 am |
| Hey,
I am planning to upgrade my copy of SQL 2005 Evaluation Edition (2
instances) to SQL 2005 Workgroup Edition. According to Microsoft this
is possible and supported as an upgrade path.
Any tips or ideas would greatly be appreciated. I also thought to stop
the SQL services and make a copy of the DBs as a backup. And if
anything goes wrong, uninstall the Evaluation version, install
Workgroup Edition and replace the DBs with the originals. Would this
also work? I know I can also do a backup/restore but would like to
avoid re-creating all the user accounts.
Thanks!
| |
| John Bell 2006-03-25, 1:23 pm |
| Hi
You should backup all the databases before you start just in case anything
goes wrong, your fall back will be re-install and restore.
You can script logins from SQL Server Management Studio, although this will
be individual ones.
John
"Andre S" <andre.smith@gmail.com> wrote in message
news:1143297719.533654.7760@e56g2000cwe.googlegroups.com...
> Hey,
>
> I am planning to upgrade my copy of SQL 2005 Evaluation Edition (2
> instances) to SQL 2005 Workgroup Edition. According to Microsoft this
> is possible and supported as an upgrade path.
>
> Any tips or ideas would greatly be appreciated. I also thought to stop
> the SQL services and make a copy of the DBs as a backup. And if
> anything goes wrong, uninstall the Evaluation version, install
> Workgroup Edition and replace the DBs with the originals. Would this
> also work? I know I can also do a backup/restore but would like to
> avoid re-creating all the user accounts.
>
> Thanks!
>
|
|
|
|
|