SQL 6.5 to SQL 7.0 problem | SQL Server Performance Forums

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
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.