Uploaded image for project: 'Compass '
  1. Compass
  2. COMPASS-3583

Migrate SQL data into MongoDB via Compass plugin/feature

    XMLWordPrintableJSON

Details

    • Icon: New Feature New Feature
    • Resolution: Incomplete
    • Icon: Major - P3 Major - P3
    • None
    • None
    • Plugins
    • None

    Description

      Studio3T have quite an advanced SQL to MongoDB Migration wizard. It seems to be able to connect to any SQL Server and includes some UI for defining relationships between tables to create structured documents with arrays etc during the import process.

      Since we don't have any official/home-grown tools for transforming SQL data during import, I think Compass would be a great place to introduce such a feature.

      This could include some tips/heuristics to help first-time customers define a scalable, performant schema, including:

      • recommending data types (e.g. date detection from string)
      • bucketing options for time-series
      • detecting unique field for reuse as _id field
      • shorter field names
      • JSON Schema

      Attachments

        Activity

          People

            Unassigned Unassigned
            nicholas.cottrell@mongodb.com Nic Cottrell
            Votes:
            2 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: