Post reply

SQL Server 2000 to 2005 Migration Steps

  • October 17, 2008 at 3:43 am

    #194677

    Hi all,

    Could any one assist me on SQL server migration steps from SQL Server 2000 to SQL Server 2005?

    It would be very helpful if you give me complete instructions.

    Thanks,

  • October 17, 2008 at 4:10 am

    #886243

    Hi,

    Check this reference guide:

    http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en#QuickInfoContainer

    [font="Verdana"]Renuka__[/font]

  • October 20, 2008 at 11:31 am

    #887250

    Hi there, what exactly are you planning to migrate?all your database objects?sp,tables,views,data,dts,users,roles,schemas?just everything?

    I had to do a migration and what I did was just to restore a backup on 2k5, changed compatibility level to 90 (sql 2k uses compat level 80) and then started 'cleaning' my db. You might get some problems if you have to migrate users and logins with the same passwords, because you may have an IT Security department that will assign new passwords for the logins you have decided to migrate. But just let us know what you are doing, and I'll try to help in some way.

    Ah btw, something really important is that both of your servers must have the same collation, so you don't get problems with your data migration. Good luck!

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

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