Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-944

package schema for backup/restore

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Fixed
    • None
    • None
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    Description

      Backup/Restore need to be able to drop the current database and then create a database of any version for importing old data.

      The process is dropDb(), createTables(int version), (insert data), addConstraints(), update().

      To do this we will ship and store schema creation scripts for each type of database supported. The scripts will be broken into:-

      • dbname-tables-version.sql
      • dbname-constraints-version.sql
      • dbname-drop-version.sql

      the dbspecific scripts will be stored in a separate directory, currently hsql, mysql, postgresql.
      (not part of this jira) upgrade scripts will be stored in separate db specific directories too.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              pmcneil Peter McNeil [Atlassian]
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 28h
                  28h