• parthi-1705 (11/30/2009)


    Hi

    I am having SQL 2000 in it 10DB are there i would like to Migrate them to SQL 2005 but not using the migration Wizard.I am just taking the Backup and resote it.

    There are N Numser of users are there in each DB i know some of the UserdId and Password,for some i dont know.How to match the users for each DB,each users might have some permissions i too dont know the permissions and userid,password for it.How to get those to update in SQL 2005 is any way there.

    Thanks

    Parthi

    Hi Parthi,

    Check the following link

    Transfer logins and passwords from SQL Server 2000 to SQL Server 2005

    Search here u'll get more info.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/