Manual relationship with no columns

A manual relationship is defined with no columns.

How to fix

Add the missing sourceColumns and targetColumns arrays to your manual relationship.

Problem example:

{
  "manualRelationships": [
    {
      "sourceTable": { "schema": "dbo", "name": "Orders" },
      "targetTable": { "schema": "dbo", "name": "Customers" }
      // Missing sourceColumns and targetColumns
    }
  ]
}

Fixed:

{
  "manualRelationships": [
    {
      "sourceTable": { "schema": "dbo", "name": "Orders" },
      "sourceColumns": ["CustomerId"],           // Added
      "targetTable": { "schema": "dbo", "name": "Customers" },
      "targetColumns": ["Id"]                    // Added
    }
  ]
}


This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?