Upgrade SQL Database

[NicholasBarger]

We are in the process of migrating to ArcGIS10, however; before we do this we need to upgrade our SQL Server database.

I was told that there was a way to write the user accounts and password information to a file that can be imported after the upgrade is performed.  Does anyone know what the command line syntax is?

We have been delaying our upgrade because we do not know what some of the passwords are.

[RobertHu]

Hi Nicholas,

I don't have a sure solution for you. But based on what we did in Oracle, I think you can do it in SQL Server this way,

1. Export user name and password_hash information from sys.sql_logins system view to a text file.
2. Run CREATE LOGIN <loginName> WITH PASSWORD = <hashed_password> HASHED <other options>, where the loginName is a user name from the text file, the hashed_password is the associated hashed code.

Hopefully this is what you are looking for. Thanks!