MSSQL 2000 Upgrade Compatibility to MSSQL 2005
Actually I need to find out the compatibility of the MSSQL 2000 upgrade with MSSQL 2005. MSSQL 2000 was installed inside the Citrix box. I did a side-by-side upgrade by maintaining a database and restoring on my local machine. Now I need to find out if the applications will work in MSSQL 2005.
+1
source to share
1 answer
You may need to provide more information on what these applications are, but apparently the easiest way is to redirect them to a SQL 2005 database and run your test suite to make sure they are still functioning as expected.
Remember when installing SQL 2005 to choose a collation that will work with your applications (using SQL mappings collation might be your best option here).
+1
source to share