When upgrading sql server 2000 to sql server 2008 changes affected by the current databases?
We are migrating the database of sql 2000 to sql 2008 with ANSI comparability mode 100.We are changing the old code =\* and \*= for left and right outer join and some order by changes instead of column name we added number for that respective column name.Live server having sql server 2000 database. we want to apply the changes in live server of the customer.current we testing the new back server with sql server 2008R2 The question is a. Apply all corrections in the live server with SQL 2000 and then upgrade the production server to SQL2K8 OR b. Upgrade the Production server to SQL2K8 and then apply the corrections. Which one is best method.
Personally I would make a copy of the database, restore it to a test server, upgrade it, make the changes and test that it produces the same output as the production version and then repeat the process on the production database. Why are you using the column number to sort the datasets. This is a path to causing yourself problems in the future.