File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005

 
sumanta panda
Ranch Hand
Posts: 224
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear All,
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.

Regards
Sumanta Panda
 
Nathan Pruett
Bartender
Posts: 4121
IntelliJ IDE Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic