This week's giveaway is in the EJB and other Java EE Technologies forum.
We're giving away four copies of EJB 3 in Action and have Debu Panda, Reza Rahman, Ryan Cuprak, and Michael Remijan on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB2 Compatable Database  ? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB2 Compatable Database  ?" Watch "DB2 Compatable Database  ?" New topic
Author

DB2 Compatable Database ?

Praful Thakare
Ranch Hand

Joined: Feb 10, 2001
Posts: 613
Hi,

I have an scnairo where we need to develop an application on some freeware database like,MYSQL or Postgres and then migrate it to DB2.
Now I need help in knowing which database will be more compatible with DB2,I mean to ask with respect to functions supported.
also I have heard abt some limitations in sub queries by MSQL.

And lastly dose DB2 have any kind of tool which helps in migration for both database?

Waiting for experts Comments

Cheers
-Praful


All desirable things in life are either illegal, banned, expensive or married to someone else !!!
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

Praful,
I'm moving this to JDBC since it is about db2, not Oracle.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29220
    
135

Praful,
The goal should be to use standard SQL. Then you can use any database without changing/converting the queries. MySql and Postgres support standard SQL. Just try to avoid using any of their proprietary functions.
Praful Thakare
Ranch Hand

Joined: Feb 10, 2001
Posts: 613
Howdy Jeanne,

Thanx a bunch for your reply.

Cheers
-Praful
Adeel Ansari
Ranch Hand

Joined: Aug 15, 2004
Posts: 2874
agreed with Jeanne about using the standard SQL or ANSI syntax.

but i am also thinking about container managed persistance. what you people say? if using persistance layer, we bother less about the database below.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: DB2 Compatable Database ?
 
Similar Threads
Generic way of data transfer
DB2 needed on Application Server?????
export/import
Jar file for DB2 Connection?
DB2 Stored procedures written in Java