Re: documenting tables version control

Tim Clarke <tim.clarke@xxxxxxxxxxxxxx> · Wed, 06 May 2015 09:47:32 +0100



    We keep the DDL statements for any tables in our subversion code
    repository just like any other programming code. Takes only a moment
    then all history or changes is available and comparable. svnserve on
    our linux server, svn workbench on my ubuntu laptop, all open source
    :)

    
    Tim Clarke
    On 05/05/15 21:13, Suresh Raja wrote:

    
            Hi All:
            

            I have tables with different versions in the same
              schema.  Like 
            T1a, T1b, T1c
            T2a, T2b, T2c, T2d
            ....
            ...
            etc.
            

            I'm interested in documenting various version of
              tables, may be in excel sheet or may be in another schema
              in the database.  I would like to store information on
              table name, column names, column order, pry key column
              etc.  Also is there a way I can reverse engineer from the
              database itself.
            

            Let me know if anybody any suggestion or format that
              they used.  I appreciate all your help and shall be
              suitably acknowledged. 
            

            Thanks,
            -Suresh Raja