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

Migrate SQL data into MongoDB via Compass plugin/feature

    • Type: Icon: New Feature New Feature
    • Resolution: Incomplete
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: Plugins
    • None

      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

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

              Created:
              Updated:
              Resolved: