• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database Migration (Migrating only Tables, leaving Views)

 
Tauri Valor
Ranch Hand
Posts: 181
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi


Im doing a Database Migration from HSQL to DERBY..

I need to migrate only the tables in the HSQL to DERBY..

But when I use the following code :



The above code migrates tables but it also migrates Views and creates new tables in detination database with the name of the view in source database.

Now I need to get only the tables leaving out the views...

Can any one pls track out the problem ?

Thanks,
Sud
 
Tauri Valor
Ranch Hand
Posts: 181
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I found the solution myself


Once I got the list of tables and views, I checked the

tableType = rs.getString("TABLE_TYPE")

value to know if it is Table or a View.


Hope this helps somebody....

Cheers,
Sudheer.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic