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
Migrating SQL Server 7.0 to 2005
Dan Wahlin
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
ToddNR
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
JohnVP
Attach/detach won't be bothered a bit by OS upgrade. Go for it!
Paul