Upgrading 7 to 2000 – General guidance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Upgrading 7 to 2000 – General guidance

We are going to embark on an upgrade of two separate database that we developed originally by a partner that is no longer on either of our two programs. Given how the relationship ended, we can not expect much in the way of support from them for this upgrade. There are stored procedures, jobs, processes, and other possible pitfalls that we are not fully aware of at this time. Any general hints, tips, guidance, etc. that can make this transition go easier would be greatly appreciated. Thanks Bob
Here are some help: http://www.microsoft.com/technet/itcommunity/chats/trans/SQL/sql0305.asp Luis Martin
See… http://www.sqlteam.com/item.asp?ItemID=9066
http://www.sqlteam.com/item.asp?ItemID=9465
http://www.edgewoodsolutions.com/resources/SQLServerUpgrade_1.asp
http://www.edgewoodsolutions.com/resources/SQLServerUpgrade_2.asp Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
Go thru the MS & SQL Team links provided by Luis & Gaurav which are explained in-detailed. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
Thanks folks for the rapid turnaround on this. I have passed your links to my App/Dev folks so that they can benefit from them before attempting the first pass on this.<br /><br />I will keep you updated on the results.<br /><br />Bob[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]
As a DBA I would propose you to keep in mind about COLLATION changes between ver 7 and 2K, refer thru this DB Journal articlehttp://www.databasejournal.com/features/mssql/article.phpr/1587631 which tackles the issues, as you’d referred articles to Developers. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>