Wednesday, March 21, 2012

Migrate SQL 2000 to SQL 2005

We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
I don't mind doing an un-install or SQL 2000 then a clean install of SQL
2005 x64 but my problem is a large number of SQL logins
Is there any easy way to export SQL logins and passwords from SQL2000 and
import them into SQL2005?
Thanks
Peter LawtonHi
This can be run on your SQL 2000 installation
http://support.microsoft.com/kb/246...122120121120120
John
"Peter Lawton" <devnull@.fakedomain.com> wrote in message
news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
> We want to migrate some x64 servers from 32bit SQL 2000 to 64bit SQL 2005
> I know that upgrading SQL 2000 to x64 SQL 2005 isn't possible and I expect
> upgrading x32 SQL2005 to x64 SQL2005 isn't possible either.
> I don't mind doing an un-install or SQL 2000 then a clean install of SQL
> 2005 x64 but my problem is a large number of SQL logins
> Is there any easy way to export SQL logins and passwords from SQL2000 and
> import them into SQL2005?
> Thanks
> Peter Lawton
>|||mant thanks - that looks like just what I need!
Peter Lawton
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ehKcwoUCGHA.2908@.TK2MSFTNGP09.phx.gbl...
> Hi
> This can be run on your SQL 2000 installation
> http://support.microsoft.com/kb/246...122120121120120
> John
> "Peter Lawton" <devnull@.fakedomain.com> wrote in message
> news:uktsVlHCGHA.4040@.TK2MSFTNGP12.phx.gbl...
>

No comments:

Post a Comment