Uploaded image for project: 'OpenMRS Core'
  1. OpenMRS Core
  2. TRUNK-1925

Support Multiple Databases in OpenMRS Installation and Update

    XMLWordPrintable

    Details

    • Complexity:
      High

      Description

      liquibase-schema-only.xml
      -------------------------
      Non-Generic datatypes are used that cannot be translated to a mssql database.
      Precision is specified on various integer datatypes, which cannot be translated to a mssql database.
      There is a float(11, 5) that should probably be numeric(11, 5)

      liquibase-update-to-latest.xml
      ------------------------------
      Incompatible data lengths on a constraint: <column name="edit_privilege" type="varchar(255)" /> should probably be "varchar(50)"
      The "daemon" user is referenced as a "creator" before being added to the "users" table.
      Precision is specified on various integer datatypes, which cannot be translated to a mssql database.
      Constraints dropped before being created.
      Liquibase tag "addAutoIncrement" not supported for mssql database.
      Incorrectly escaping single quotes for mssql database.
      Aliasing a table in an UPDATE statement not supported by mssql database.
      Typo in 20090214-2247 end paren with no start paren. (Maybe? add the "CONCAT(" that is missing, if it supported by these db's.)
      Changeset 20090214-2248 should not use the CONCAT() function as it is not supported by mssql database. (can just remove the extraneous close paren.)
      Can't change the datatype of columns with default values on them. (<dropDefaultValue tableName="cohort" columnName="voided"/> first)
      Can't change the datatype of columns with indexes on them.

      See this discussion: http://forum.openmrs.org/viewtopic.php?f=9&t=732&p=2780#p2780

      Initialization wizard
      ------------------------------
      Postgres does not support "create table if not exists" as mysql does.

      Support many databases
      ---------------------
      OpenMRS should support many databases(MySQL, SQL Light, Postgres, SQL Server....). And this behavior should also include in module "Install Wizard".
      See https://listserv.iupui.edu/cgi-bin/wa-iupui.exe?A2=ind1107&L=OPENMRS-DEVEL-L&D=0&T=0&X=24FA6E4A6E2D3660C7&Y=sokha%40instedd.org&P=181564

        Attachments

        1. image003.jpg
          image003.jpg
          2 kB
        2. image003.jpg
          image003.jpg
          2 kB
        3. liquibase-demo-data.zip
          272 kB
        4. logic-0.5-SNAPSHOT.omod
          4.96 MB
        5. postgres-workaround.patch
          2 kB
        6. TRUNK-1925-final.patch
          15 kB
        7. Work-In-Progress-Until-Installation.patch
          66 kB

          Issue Links

            Activity

              People

              Assignee:
              sunbiz Saptarshi Purkayastha
              Reporter:
              adamarmistead Adam Armistead
              Votes:
              2 Vote for this issue
              Watchers:
              8 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: