Originally posted by Sudhakar Chavali:
Personally I hate using MS SQL Server for Java/J2EE based applications.
Any particular reason?
Most of my database experience is with Oracle, but what I've seen of MS SQL Server I have liked. It has a nice integrated user interface. Oracle's user interface is primitive, cryptic and spread across numerous apps.
It has an auto increment type whereas Oracle insists one jump through hoops setting up a sequence and trigger.
Data Transfer Services is a lifesaver if one has numerous data sources that have to be scrubbed and imported.
If the client wants MS SQL Server, use it. One of the great things about
Java's APIs is vendor-independence, being able to pick and choose the various tools for a job. Don't tick off your client just because he wanted you to use Brand X hammer rather than your preferred Brand y.