How can we improve our Oracle tools?

Data should be a part of the version control for metatables

Some tables are metatables involving data/information connected to the software releases. The Source Control utility should have a possibility of setting a switch on the tables, turning data compare on. This way you could include data for these tables in the version control.

104 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Lasse JenssenLasse Jenssen shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    Herbert.DammHerbert.Damm shared a merged idea: Data Compare for Oracle should also compare database data against SVN Source Control - like SQL Data Compare does  ·   · 
    planned  ·  Richard MitchellAdminRichard Mitchell (Project Manager, Red Gate) responded  · 

    We plan on supporting comparison to data using Source Control this year.

    I was wondering what format is best for the data as stored in source control, SQL, CSV, some oracle specific format.

    What do people think?

    10 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • arvindarvind commented  ·   ·  Flag as inappropriate

        Will the planned work also include the restore of schema (default) data using SCO itself ??

      • Robert EvansRobert Evans commented  ·   ·  Flag as inappropriate

        We need to be able to add certain tables to source control , then the redgate product to produce a script of changes i.e. insert, update and delete statements, based on the table primary key. The automated script would then be part of a release.

      • Mark IllumMark Illum commented  ·   ·  Flag as inappropriate

        my first instinct is sql insert statements. This would be similar to how objects are stored (sql create statements). It would also need to know/store which columns are ok to be different, like meaningless keys, and something like create date.

      • Iulian GhineaIulian Ghinea commented  ·   ·  Flag as inappropriate

        We need also this feature. A complete schema in SVN has ddls but also table data (constant data). This is necessary for a complete deploy.

      • Sylvain PointeauSylvain Pointeau commented  ·   ·  Flag as inappropriate

        Would be splendid, I struggle doing my own script to generate easily the master data. I hit a lot of border cases and I really missed a tool capable of it and bullet proof.

      Feedback and Knowledge Base