Post reply

Side by Side Migration from Sql2k to Sql 2k5

  • June 20, 2007 at 7:55 am

    #117444

    I've done some testing with a new Sql2k5 Dev Server. I used the detach/attach method to migrate the databases.  Of course, like others have complained, I've had some login/permission problems. I do know about sp_help_resolve_logins and the other related sp's. My question is: It seemed to me that I had less issues with logins when I moved all of the logins first, and then copied and reattached the databases. I haven't seen any info/article that confirmed that this was the preferred order in the migration process. Any thoughts?

    thanks,

    Dave

     

  • June 20, 2007 at 11:56 pm

    #714251

    Hi. I will be migrating from 2000 to 2005 soon. I did some testing but had to use the sp_change_users_login to solve login problems. In the coming days I will do the real migration and will try to do as you suggested.. ie: move logins first and see what happens.

    Thanks for suggesting.

    Mario

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

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