Getting started

Import manually (SSMS)

The by-hand path for a one-off or occasional import. See Import a schema for the security notes. The extractor is published on GitHub so you can read it before running it.

1. In the workspace Overview, click Start schema import, then Copy extractor script.

2. Run it in SSMS with Results to Grid — the default. Do not switch to Results to Text.

   Results to Text caps at 8,192 characters and truncates the JSON; Grid holds the whole value.

3. Raise the grid cell limit: Tools → Options → Query Results → SQL Server → Results to Grid → Maximum Characters Retrieved → Non-XML data, and set it to 2000000.

   It binds only to NEW query windows — open a fresh one after changing it, or it will not take effect. This is the step people miss.

4. Copy the result with Copy Cell (right-click) or Shift+F2 — not Ctrl+C, which copies the truncated display.

5. Paste it into the import panel, or use Upload .json. Click Preview import, then Commit import.

If the script errors on a permission, you likely need VIEW DEFINITION on the objects being read — but most logins that can already query the database have it.