Hi Friends, Actually I have to find out the compatibilty of the upgrade of MSSQL 2000 to MSSQL 2005. The MSSQL 2000 was installed inside the Citrix box . I did a side by side upgrade by backing up the database and restoring in my local machine. Now I have to figure out if the applications will work in MSSQL 2005.Can somebody please, give me idea how can I do it. Please,help me out, I will really appreciate it. Thanks, Angelina
+1
A:
You might need to give more information about what these applications are, but presumably the easiest method is to redirect them to point to the SQL 2005 database and run your test suite to see whether they still function as expected.
Remember when doing the installation of SQL 2005 to choose a collation that will work with your applications (using a SQL 2000 compatible collation may be the best option here).
Greg Beech
2008-11-11 01:47:17
A:
Thanks for the quick answer. Actually MSSQL is installed inside a citrix server. So I need to know if it will still work fine in that box if we upgrade it.
Thanks, Angellina
You should add this information to the original question by editing it, and then delete this post. Then future answerers can see the whole problem in one go. If the issue is with Citrix rather then SQL compatibility, I'll leave it to others to answer as that isn't my area.
Greg Beech
2008-11-11 02:03:03
Agreed. Please move this post into your original question. It will help get you an answer faster. Additionally, all posts are considered answers to your question, which this is not.
Jason Jackson
2008-11-16 02:38:43