Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005
Post by:sumanta panda
, Ranch Hand
We have developed our application in j2ee technology where we used Struts ,EJB and SQL Server 2000.
In our java program we have written SQL queries.Sometimes we have also written Dynamic sql queries.
While migrating from SQL Server 2000 to SQL server 2005 what are types of changes required for java code where we have written sql query.
Please advise or guide me for the pointer of the URL so that it helps me to achieve my milestone.
Please share your input.
Thanks in advance.
Post by:Nathan Pruett
It's probably not the "Java code" itself that's going to change - it's going to (possibly) be stuff like changing database connection information, and SQL queries. Now as for how much change - I don't know... I'm not sure how much changed between SQL Server 2000 and 2005.