SQL Server Performance Forum – Threads Archive
SQL 6.5 to SQL 7.0 problemHi, 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
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.