Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

migrating a database to another programmatically

 
Tiju Thomas
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any java utility to programmatically copy a database to another (say from sqlserver to derby)? I found org.apache.ddlutils but it suggests using ant. I wanted to do it programmatically using java. Any idea is helpful
 
Scott Selikoff
author
Saloon Keeper
Posts: 3886
14
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are plenty of off the shelf, comercial solutions but not many via an embedded library. In general, though, I've found it doesn't take much work to write one yourself for a specific task. If you use the meta data API, you can read a database and create a file of SQL create/insert commands, formatted for the new database. Then just call a bulk script on the file and load it into the new database. In general, converting a database is non-trivial process so doing it yourself gives you a lot of control of what goes to what.
 
Tiju Thomas
Greenhorn
Posts: 22
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Scott Selikoff wrote:If you use the meta data API, you can read a database and create a file of SQL create/insert commands,


Thanks much Scott. How exactly we can create a file of SQL from the metadata? Do we have any code sample over the net anywhere?
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic