wood burning stoves 2.0*
The moose likes Other Application Frameworks and the fly likes Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Frameworks » Other Application Frameworks
Bookmark "Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005" Watch "Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005" New topic
Author

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

sumanta panda
Ranch Hand

Joined: Jun 23, 2008
Posts: 224
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

Joined: Oct 18, 2000
Posts: 4121

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.


-Nate
Write once, run anywhere, because there's nowhere to hide! - /. A.C.
 
 
subject: Code compatibilty in j2ee application while migrating from SQL Server 2000 to SQL Server 2005