Quantcast

[jira] [Created] (DDLUTILS-288) Table Schema is not exporting completly

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[jira] [Created] (DDLUTILS-288) Table Schema is not exporting completly

JIRA jira@apache.org
Tej Kiran Sharma created DDLUTILS-288:
-----------------------------------------

             Summary: Table Schema is not exporting completly
                 Key: DDLUTILS-288
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-288
             Project: DdlUtils
          Issue Type: Bug
    Affects Versions: 1.1
            Reporter: Tej Kiran Sharma
            Assignee: Thomas Dudziak


Hi,

I have recently downloaded DDLUtils and tried to export schema and data for large database.
Case 1: It shown exported schema successfully, but there was missing some constraint and explorting all table's create query.

Case 2: Could not exported data of table.

<?xml version="1.0"?>

<project name="test" default="writeDDLToXML" basedir=".">

<!--<path id="runtime-classpath">
  <fileset dir="../dist">
    <include name="**/*.jar"/>
    <include name="**/*.zip"/>
  </fileset>
  <fileset dir="../lib">
    <include name="**/*.jar"/>
    <include name="**/*.zip"/>
  </fileset>
</path>-->

<path id="runtime-classpath">
<fileset dir="./lib">
<include name="**/*.jar"/>
</fileset> </path>

 <!-- This will output all the object in the database 'test' and output the schema definition
   to a file 'db-schema1.xml'. This will also extract the data and output this to 'data.xml'
  -->
<target name="writeDDLToXML" description="Dumps the database structure">
  <taskdef name="databaseToDdl"
           classname="org.apache.ddlutils.task.DatabaseToDdlTask">
    <classpath refid="runtime-classpath"/>

  </taskdef>
 
  <databaseToDdl verbosity="debug">

 <database url="jdbc:postgresql://localhost/APEOM"
              driverClassName="org.postgresql.Driver"
              username="postgres"
              password="password"/>
   
   
    <writeSchemaToFile outputFile="db-schema_myExportData.xml" failonerror="false" />
    <!-- Comment line below if the source DB is too big -->
    <writeDataToFile outputFile="schema_myExportData.xml"/>
  </databaseToDdl>

</target>

<target name="writeDDLToSQL" description="Dumps the database structure" depends="writeDDLToXML">
  <taskdef name="databaseToDdl"
           classname="org.apache.ddlutils.task.DatabaseToDdlTask">
    <classpath refid="runtime-classpath"/>

  </taskdef>
  <databaseToDdl verbosity="debug">
    <database url="jdbc:postgresql://localhost/APEOM"
              driverClassName="org.postgresql.Driver"
              username="postgres"
              password="password"/>

    <writeSchemaSqlToFile outputFile="db-schema_myExportData.sql" dodrops="true" failonerror="false" alterdatabase="false"/>
  </databaseToDdl>
</target>

</project>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Loading...