|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, May 10, 2013 9:28 AM
Points: 20,
Visits: 169
|
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Tuesday, May 08, 2007 12:12 AM
Points: 12,
Visits: 1
|
|
Thanks for the excellent article. One thing I do miss, as with other upgrade resoruces/articles I have read so far, is that the upgrade is entirely focused on the server upgrade. There is not much mentioned about the client upgrade process.
BR /Minh
|
|
|
|
|
SSCertifiable
       
Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462,
Visits: 1,384
|
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Thursday, September 06, 2007 4:24 AM
Points: 5,
Visits: 1
|
|
Mhoac and Andy - Thank you both for the valuable feedback. Since this is a series of upgrade articles, I will include the client portion of the upgrade in a future article. Stay tuned!
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Friday, October 14, 2011 2:32 PM
Points: 56,
Visits: 12
|
|
I love the article, straight forward, etc. I've read a few upgrade articles recently because a client is upgrading from SQL 7 to SQL 2000. I've been running their database on my local server to see if there are any issues in the upgrade, and found exactly 1 (so far). It involves differeneces in SQL. They are using a lot of statements such as this: convert(money(2), somevalue) This throws an error in SQL 2000 because, well convert changed from 7 to 2k. The statement works fine on 2000 this way: convert(money, somevalue) So far I've had a hard time find information on similar problems in upgrading from 7 to 2000. If I were doing a 6.5 upgrade I would have that handy tool microsoft issues which helps find some of these kinds of problems. Too bad it doesn't work with 7.0 databases.
|
|
|
|