locked
Migrating SQL Server 7.0 to 2005 RRS feed

  • Question

  • I am in the process of migrating from [Source] SQL Server 7.0 sp4 on windows NT to [Target] SQL Server 2005 on Windows 2003 Server.

    Please suggest me what should be the migration approach it this case.

    Would De-attach and attach of DB still be valid if OS changes? (both are 32 bit OS).

    regards

    Thursday, May 18, 2006 10:19 AM

Answers

  • Attach/detach won't be bothered a bit by OS upgrade. Go for it!

     

    Paul

    Thursday, May 18, 2006 9:00 PM

All replies

  • Attach/detach won't be bothered a bit by OS upgrade. Go for it!

     

    Paul

    Thursday, May 18, 2006 9:00 PM
  • thanks paul for the reply.

    I tried the deattach and attach process it worked on fine. I just thought how can i get the log of the migration which SQL server 2005 is doing by upgrading the Data files and log files also what all things are upgradable and what all things fail?

    To find out that I would be requiring the log file. Any idea about this?

    Tuesday, May 23, 2006 11:38 AM
  • I too am migrating from SQL Server 7.0 on NT to SQL Server 2005 on Windows Server 2005.

    Is Detach/Attach the best way to do it or are other methods better? (e.g. backup/restore). If so which one?

    I have let to run Upgrade Advisor, will this recommend a method?

    What kinds of changes are necessary to Transact SQL (including stored procedures and triggers)?

    Regards,

    Peter

    Wednesday, May 31, 2006 11:42 AM