Post reply

trouble with schema and login/user when moving to new server

  • July 3, 2008 at 5:04 pm

    #184287

    I am transfering a database from 2000 to 2005. The application has a login and user "hyperion".

    Normally, I would drop the user from the database. Then create the login on the server, and create the user the database again.

    Unfortunatly, all of the obects belong to the schema "hyperion", so I can not delete the user.

    I thought about transfering each object in the schema to .dbo. Then delete the user. Then create the login and user. Then transfer the schema back.

    Something like this repeated for every object

    ALTER SCHEMA dbo

    TRANSFER hyperion.HBRCacheEvents

    .....

    ALTER SCHEMA hyperion

    TRANSFER dbo.HBRCacheEvents

    .....

    There has to be a faster/cleaner way than this.

    Any suggestions?

    Orange Crusher
    i love it!

  • July 4, 2008 at 4:35 pm

    #838449

    Can you try using sp_help_revlogin script and just create this Hyperion login on destination server and map it with database user there using sp_change_users_login stored procedure.

    support.microsoft.com/kb/246133

    Manu

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply