1 Reply Latest reply on Nov 8, 2012 9:38 AM by Ramesh Reddy

    Teiid VDB export

    Emil Cervenan Newbie

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

        • 1. Re: Teiid VDB export
          Ramesh Reddy Master

          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..

          1 of 1 people found this helpful