Import a schema

Watch import progress

While a script import runs, its detail page shows live progress: what it’s working on, how far each stage has got, and the status of every object in the script.

In the app: Settings › Organization Settings › Schema Imports › open icon on an import

[screenshot]
A schema import in progress: the status banner, the summary card, Phase Progress, and the All Items grid.

Before you start

The Schema Imports tab is part of Organization Settings, which only organization admins can open.

Get to the page

  1. After you click Start Import, Kenseme opens Organization Settings › Schema Imports. You can also go there any time from the sidebar.
  2. Find the import. The list shows Schema, File, Status, Progress, Started and Duration.
  3. Click the open icon (View import details) on its row.

The list also has cancel and resume buttons on each row, and Refresh.

The status banner

The banner at the top depends on the import’s status.

Status What you see
Processing A spinner, a line describing the current step (for example Creating 12 tables... or Parsing foreign key relationships...), X of Y objects completed — running for …, and a Cancel button.
Completed Import completed successfully — N objects created in …
CompletedWithErrors How many objects failed, with advice that depends on the count (see below).
Cancelled Import cancelled, how many items can be resumed, and Resume Import.
Failed Import failed. with the reason. The import stopped before finishing.

When an import completes with errors:

  • Up to 5 failures: Click "Fix" on each item below to edit the DDL and retry, with Resume All Failed.
  • 6 to 15 failures: a suggestion to fix the source file and re-import if the failures share a cause, with Resume All Failed.
  • More than 15 failures: too many to fix individually. Fix the source file and re-import to a new schema., with Download Failed DDL, which downloads the failed objects’ DDL in one file.

The summary card

The card is titled with the file name and status. It shows Schema, Started, Duration, Succeeded and Failed counts, and an overall progress bar. The page refreshes itself every few seconds while the import runs; Refresh reloads it by hand.

Phase Progress

One bar per stage that has work: Tables, Indexes, Relationships and SQL Objects, each with completed and total counts.

Tip: On a large file, the tables stage takes longest. Each table is parsed on its own.

Currently Processing and Failed Items

While the import runs, this card lists objects being worked on. Afterwards it lists failed objects, each with its type, name and a short error.

All Items

A paged grid of every object in the script, which you can filter and sort:

  • Object Name and Type (Table, Index, Relationship, View, StoredProcedure, ScalarFunction, TableValuedFunction).
  • Status: Pending, Processing, Succeeded, Failed or Skipped.
  • Description: error details for failures, or why an item was skipped.
  • Duration.
  • Actions on failed and skipped items: the replay icon retries without changes; Fix opens the fix dialog. Fix is disabled when an object this item depends on also failed; hover it to see which one to fix first. These actions only appear when 15 or fewer items failed.

Skipped usually means the object already existed in the schema. The script import never overwrites existing tables.

Cancel an import

  1. Click Cancel in the banner.
  2. Confirm Yes, Cancel Import.

Objects already created stay in the schema. Unfinished items become resumable.

Resume an import

  • After a cancel, click Resume Import.
  • After a completion with errors, click Resume All Failed.

Both re-queue every pending and failed item and set the import back to Processing.

Tip: If many items failed for the same reason, fixing the source file and importing again is usually faster than resuming.