Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1264

Migration plugin filter

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Won't Do
    • Affects Version/s: Icebox
    • Fix Version/s: N/A
    • Component/s: Core
    • Labels:
      None

      Description

      The idea is for a filter plugin that can be used to simplify migrations, In some ways, the suggested filter could probably also be implemented as a number of regex filters, but that would possibly require a large number of different filters and some rather complex pattern matching. The idea here is to replace, typically in an SQL statement, some Oracle specific SQL with MariaDB friendly SQL. This is sometimes useful even in production, but probably even more so when testing, migrating or running a POC.
      Examples features would be (for an Oracle migration filter):

      • Map DECODE to CASE statements
      • Map SYSDATE to NOW()
      • Oracle outer join (using ) to ANSI-style OUTER JOIN
      • Quoted identifiers to backticks
      • Map || to CONCAT for concatenation

        Attachments

          Activity

            People

            Assignee:
            toddstoffel Todd Stoffel
            Reporter:
            karlsson Anders Karlsson
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration