Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-user@db.apache.org
Received-SPF: pass (herse.apache.org: domain of tomdzk@gmail.com designates
 66.249.92.168 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=WJHWBUeZ+Dcp1ZTPVlmjSxENFICkm/yWC95QJZG8n9eSGi8qGyu5nmyIiTP7qdvf1mt586DH5RpjQNVK5Y03j3izkkA+Op2QbSfhnA9P8nZJzbkf8JTN1yKRpg/qJbffdgY0rthgPnRxPTcu4El+L5xuiPJwfmOBJdg8jUoBx78=
Message-ID: <224f32340701181908k7b0c9c63ib9318f4ca2a79907@mail.gmail.com>
Date: Thu, 18 Jan 2007 19:08:21 -0800
From: "Thomas Dudziak" <tomdzk@gmail.com>
To: ddlutils-user@db.apache.org
Subject: Re: Selective Export
In-Reply-To: <20070115144756.47081.qmail@web34415.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <20070115144756.47081.qmail@web34415.mail.mud.yahoo.com>

On 1/15/07, Laurent ROCHE <laurent_roche@yahoo.com> wrote:

> I am trying to export only a part of my data from PostgreSQL to Derby.
> I am using the Ant tasks of DDL Utils.
>
> Ideally, what I would like to do is to be able to run DDL-Utils export data on a SQL request not tables.
> Nearly as good, will be to run DDL-Utils on a view (I will have to create the view and drop the view when finished).
>
> Tom told me on this mailing list (on Dec. 14th):
> DdlUtils currently cannot create views (though it can read from them
> if VIEW is included in the table types (a parameter of the Ant task).
> I thought it meant that DDL-Utils will not manage schema but data. But from my tests, it seems that DDL-Utils does not manage data for views (i.e. does not export data, as import for views won't mean much), and exports the schema with views.

In order to be able to read data from views, you probably have to
specify "TABLE, VIEW" for the tabletypes parameter
(http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.DatabaseToDdlTask.html#parameter-tabletypes).
If that doesn't work, then could you please use the dumpMetadata task
(http://db.apache.org/ddlutils/ant/org.apache.ddlutils.task.DumpMetadataTask.html)
on this database (schema) and send me the file so that I can see what
table types the database reports for the views ?

> But when importing the schema, despite the messages stating creation of tables (with the views names) nothing is created. Am I correct with this ? Is this the normal behaviour or am I doing something wrong ?

If they are in the schema XML, then this should work (though DdlUtils
will create normal tables, not views).

Tom