Return-Path: 
 <ddlutils-dev-return-180-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org
Received: (qmail 38696 invoked from network); 25 Oct 2005 17:39:02 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 Oct 2005 17:39:02 -0000
Received: (qmail 58887 invoked by uid 500); 25 Oct 2005 17:39:01 -0000
Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org
Received: (qmail 58872 invoked by uid 500); 25 Oct 2005 17:39:01 -0000
Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-dev-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-dev-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-dev@db.apache.org>
List-Id: <ddlutils-dev.db.apache.org>
Reply-To: ddlutils-dev@db.apache.org
Delivered-To: mailing list ddlutils-dev@db.apache.org
Delivered-To: moderator for ddlutils-dev@db.apache.org
Received: (qmail 80015 invoked by uid 99); 24 Oct 2005 18:23:41 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
From: "Sheeba" <sheeba@semanticresearch.com>
To: <ddlutils-dev@db.apache.org>, <tomdz@apache.org>
Subject: retrieving  database schema using ant task
Date: Mon, 24 Oct 2005 11:23:02 -0700
Message-ID: <000301c5d8c7$f9196610$7101000a@sd.semanticresearch.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0004_01C5D88D.4CBF7010"
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
Thread-Index: AcXYx/gosPL1wv9+Q+m784KIGft7dQ==
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_NextPart_000_0004_01C5D88D.4CBF7010
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi
 
I am new to ddlutils.I am connecting to sql server which has a database
testdb and it has two tables customer and orders.I am trying to retrieve
these information using ddlutils ant task.I am using the code given at the
website to retrieve database schema using ant task. When I build this,I get
the file "db-schema.xml' which has only line and says <database/>.
Could any body help me solving the problem
 
Thanks
sheeba
 
<path id="runtime.classpath">
  <fileset dir="lib">
    <include name="**/*.jar"/>
    <include name="**/*.zip"/>
  </fileset>
</path>
 
<target name="database-dump" description="Dumps the database structure">
  <taskdef name="databaseToDdl"
           classname="org.apache.ddlutils.task.DatabaseToDdlTask">
    <classpath refid="runtime-classpath"/>
  </taskdef>
  <databaseToDdl>
<database url="jdbc:microsoft:sqlserver://demo:1433;DatabaseName=testdb"
              driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
              username="user"
              password="user123"/>
    <writeSchemaToFile outputFile="db-schema.xml"/>
  </databaseToDdl>
</target>

 


------=_NextPart_000_0004_01C5D88D.4CBF7010--