Teiid VDB export

[emil.cervenan]

Can somebody point me out how to export whole DB via Teiid connection? I need to recreate DB at local for DDL(testing purposes).

[rareddy]

Emil,

Teiid server (AS7) is not considered repository for VDB artifact, so you can not export VDB as you deployed it. However, you can ask for VDB details (getVDB) and get DDL (getSchema) for a given model in a VDB through Admin API. Look at documentation as to how to use Admin API.

Otherwise you can use repositories like Modeshape or any other RDBMS(Oracle, DB2, MYSQL..) or source control systems(CVS, SVN, GIT) to add you VDB and retrieve from in its original form.

Ramesh..