[COMPASS-3583] Migrate SQL data into MongoDB via Compass plugin/feature Created: 19/Apr/19  Updated: 27/Sep/19  Resolved: 27/Sep/19

Status: Closed
Project: Compass
Component/s: Plugins
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Major - P3
Reporter: Nic Cottrell Assignee: Unassigned
Resolution: Incomplete Votes: 2
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 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


 Comments   
Comment by Massimiliano Marcon [ 27/Sep/19 ]

Closing this issue in JIRA. It's been moved to the new, unified feedback engine at https://feedback.mongodb.com/forums/924283-compass.

We are looking for input to decide how to prioritize it, so go there, look for the suggestion, vote and leave comments. If you don't find it, feel free to create a new one.

Generated at Wed Feb 07 22:33:38 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.