How can we help you today? How can we help you today?

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
AbeAxiomatic
0

Comments

3 comments

Sort by
  • DanC
    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?
    DanC
    0
  • AbeAxiomatic
    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
    AbeAxiomatic
    0
  • DanC
    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!
    DanC
    0

Add comment

Please sign in to leave a comment.