Migration from SQL SERVER 7.0 to SQL SERVER 2000

  • Hello guys!

    I am a junior DBA in one firm and we are planning to migrate our databases from SQL SERVER 7.0 to SQL SERVER 2000. Here is the situation:

    Old system

    OS : Windows NT 4.0

    Database server : SQL SERVER 7.0

    New system

    OS : Windows Server 2003

    Database server : SQL SERVER 2000

    I would like to have ideas about the requirements and the process of migrating from the old system to the new one.

    Many thanks and good day to all!


    Kindest Regards,

    Aboubakar Alhadji Ibrahim

  • Hi,

    There are lots of article about the same in the net.

    We backed up the user database and restored it in SQL Server 2005.

    Please review the following link for more info:

    http://msdn2.microsoft.com/en-us/library/ms189625.aspx

    http://msdn2.microsoft.com/en-us/library/ms190775.aspx

    Minaz

     

    "More Green More Oxygen !! Plant a tree today"

  • Thanks Minaz!

    I have started going through the msdn links u sent to me and it's interesting!


    Kindest Regards,

    Aboubakar Alhadji Ibrahim

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

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