SQL Server Performance Forum – Threads Archive

SQL 6.5 to SQL 7.0 problem

Hi, In order to transfer database from SQL 6.5 to SQL 2000, I set up the SQL 7.0 first.
And I can transfer database from SQL 6.5 to SQL 7.0, but there still some problems, such as some triggers will be lost. Is this situation a must or there some way to prevent the triggers missing problem?[:I]
Any help will be appreciated. Jason

Check: http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

In addition to Luis’s reference, ITs not advisable to transfer the 6.5 database to higher versions, not like SQL 7 to 2000. In order to obtain the advantages you must choose the UPGRADE path and which is easy will fix the issues that are persisting on 6.5 versions, whereas 7.0 is higher and well optimized. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>