Database Migration (Migrating only Tables, leaving Views)

[Tauri Valor]

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 :

......
......
......
String[] types = new String[]{"TABLE"};
 
ResultSet resultSet = dbmd.getTables(null, null, "%", types);
while (resultSet.next()) {
String sourceTableName = resultSet.getString("TABLE_NAME");
ResultSet results = dbmd.getPrimaryKeys(null, null,sourceTableName);
 
.......
.......
.......

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]

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.