-
upgrading from 7.0 to 2000
Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?
liz
-
upgrading from 7.0 to 2000 (reply)
Actually pretty simple, unless you have some very old objects(SP's triggers etc) that were from 6.5 you should be fine. Make sure you have a backup of all your DB's before you start just in case. If you want indexed views or log shipping make sure that your are upgrading to the Enterprise Edition of SQL Server
------------
liz at 2/13/2002 6:42:07 PM
Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?
liz
-
upgrading from 7.0 to 2000 (reply)
Quite an easy process. Be sure to update statistics after the upgrade. One more thing to look for in your SQL: If you counted on the fact the the group by for a query would also perform an Order By, this is no longer the case (and never should have been).
------------
liz at 2/13/2002 6:42:07 PM
Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?
liz
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|