Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-236

Sequence DDL files

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 0.7
    • None
    • Sequencers
    • None
    • High

    Description

      Create a sequencer that parses DDL files and generates the subgraph representing the relational schema. Multiple dialects should be supported, including those for Oracle, MS SqlServer, PostgreSQL, MySQL, and others. Ideally this could be done with one sequencer (since most users/admins won't care about which dialect a particular file is; they'll just want it sequenced).

      Attachments

        Issue Links

          relates to

          Feature Request - Feature requests from customers and/or users MODE-235 Federate schema information from relational sources

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed
          1.
          		 Find initial control sets of DDL files Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 2 days
          Remaining Estimate - 2 days
          2.
          		 Create initial DDL grammar and test it. Sub-task Closed Minor Randall Hauch (Inactive)

          0%
          Original Estimate - 4 hours
          Remaining Estimate - 4 hours
          3.
          		 Parse CREATE/ALTER/DROP/RENAME TABLE statements for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 1 week, 2 days
          Remaining Estimate - 1 week, 2 days
          4.
          		 Support parsing of CREATE/ALTER/DROP TABLE statements for PostgreSQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 2 days
          Remaining Estimate - 2 days
          5.
          		 Support parsing of CREATE/ALTER/DROP TABLE statements for Oracle SQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          6.
          		 Support parsing of CREATE/ALTER/DROP TABLE statements for SQL Server Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          7.
          		 Parse CREATE/ALTER/DROP VIEW statements for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 1 week
          Remaining Estimate - 1 week
          8.
          		 Support parsing of CREATE/ALTER/DROP VIEW statements for PostgreSQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          9.
          		 Support parsing of CREATE/ALTER/DROP VIEW statements for Oracle SQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          10.
          		 Support parsing of CREATE/ALTER/DROP VIEW statements for SQL Server Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          11.
          		 Parse CREATE/ALTER/DROP/RENAME DATABASE statements for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          12.
          		 Support parsing of CREATE/ALTER/DROP DATABASE statements for PostgreSQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          13.
          		 Support parsing of CREATE/ALTER/DROP DATABASE statements for Oracle SQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          14.
          		 Support parsing of CREATE/ALTER/DROP DATABASE statements for SQL Server Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          15.
          		 Parse CREATE/ALTER/DROP TRIGGERS statements for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          16.
          		 Support parsing of CREATE/ALTER/DROP TRIGGERS statements for PostgreSQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          17.
          		 Support parsing of CREATE/ALTER/DROP TRIGGERS statements for Oracle SQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          18.
          		 Support parsing of CREATE/ALTER/DROP TRIGGERS statements for SQL Server Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 4 days
          Remaining Estimate - 4 days
          19.
          		 Parse CREATE/DROP INDEX statements for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 3 days
          Remaining Estimate - 3 days
          20.
          		 Support parsing of CREATE/DROP INDEX statements for PostgreSQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 2 days
          Remaining Estimate - 2 days
          21.
          		 Support parsing of CREATE/DROP INDEX statements for Oracle SQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 2 days
          Remaining Estimate - 2 days
          22.
          		 Support parsing of CREATE/DROP INDEX statements for SQL Server Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 2 days
          Remaining Estimate - 2 days
          23.
          		 Parse more statement for MySQL Sub-task Closed Major Randall Hauch (Inactive)

          0%
          Original Estimate - 1 week
          Remaining Estimate - 1 week

          Activity

            People

              blafond Barry LaFond
              rhauch Randall Hauch (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 15 weeks, 2 days, 4 hours
                  15w 2d 4h
                  Remaining:
                  Remaining Estimate - 15 weeks, 2 days, 4 hours
                  15w 2d 4h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified