Hi Mo,

I assume it to be local views. Extract the syntax of the sql statemnet and create the view in your new db.
Pay attention to the table names referred in the sql statement, they must point to a valid tablename wich might be not in your newdb.

Play around with something like this (just hacked and not tested):

viewsql=dbgetprop("myview","view","SQL") &&extract sql view syntax
command="create sql view newview as "+viewsql &&create command to create view
set database to mynewdb && set target db
&command && create view


regards
Giesbert