User Defined Types with dependencies

I'm looking for a way to control the order in which User Defined Types are executed on an initial deployment to a blank database for my developers. By default, they all seem to appear in alphabetical order. The issue I have is that I have a table type of name CaseInvoices that contains a column for the type DelinquentCaseNumber. Clearly, DelinquentCaseNumber needs to be created first, but the "get latest" doesn't appear to recognize this dependency

Answers

  • DanCDanC Posts: 231 Gold 2
    edited October 30, 2020 3:10PM
    Hi @AbeAxiomatic

    So, unfortunately, it's not possible to change the deployment order within SQL Source Control, the tool should however detect dependencies and script out the objects in the correct order.

    Could I please ask what version of SQL Source Control you're using? 

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

  • Hi, Dan

    Thanks for the quick response! I'm currently using SQL Source Control (not Change Automation) Version 7.2.4.11418. I'll paste my CREATE scripts below for context. The scenario where this comes up is in getting a new employee set up with a blank database, and using Source Control to deploy all database objects and static data.

    PRINT N'Creating types'
    GO
    CREATE TYPE [dbo].[CaseInvoices] AS TABLE
    (
    [CaseNumber] [dbo].[DelinquentCaseNumber] NULL,
    [EntryDetail] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [InvoiceAmount] [decimal] (18, 2) NULL
    )
    GO
    @ERROR <> 0 SET NOEXEC ON
    GO
    CREATE TYPE [dbo].[DelinquentCaseNumber] FROM int NOT NULL
    GO
    @ERROR <> 0 SET NOEXEC ON
    GO
    CREATE TYPE [dbo].[CasePayments] AS TABLE
    (
    [CaseNumber] [dbo].[DelinquentCaseNumber] NULL,
    [PaymentAmount] [decimal] (18, 2) NULL
    )
    GO
  • Hi @AbeAxiomatic

    Apologies, I didn't get an email that you replied to this forum post!

    I'm going to chase up from a support ticket as I'll need some more details!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our Help Center?

Sign In or Register to comment.