Options

Baseline script giving errors

sasankjsasankj Posts: 23 New member
in SQL Change Automation
I created a baseline script for one of my DBs and it didnt generate proper script for Default Constraints. Please see below
CREATE TABLE [DCST].[XREF_REL_SETTLEMENT_COMPLAINT]
(
[SETTLEMENT_KEY] [int] NOT NULL,
[COMPLAINT_KEY] [int] NOT NULL,
[AUDIT_USER_ID] [varchar] (60) NOT NULL CONSTRAINT [DF__XREF_REL___AUDIT__4AF81212] DEFAULT -- No text is available,
[AUDIT_DATE] [datetime] NOT NULL CONSTRAINT [DF__XREF_REL___AUDIT__4BEC364B] DEFAULT -- No text is available
)

It is not able to generate the DEFAULT value, instead it geneated a text saying " No text is available"
Tagged:
· Share on Twitter

Answers

  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    Hi, thank you for your forum post.

    From your post I can see that the default value is missing from the DDL.

    I assume the database you are baselining includes the default values, can you please provide details of what the default values should be?

    What edition and version number of SQL Change Automation are you using?  For example SQL Change Automation Visual Studio extension release V3.3.19225.9927  or using the PowerShell module V3.3.19225.

    Many Thanks
    Eddie

    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • Options
    sasankjsasankj Posts: 23 New member
    SQL Change Automation  --  3.3.19197.9405
    SQL Change Automation PowerShell -- 3.3.19197.9413
    Visual Studio 2017 SQL Change Automation Core Extension -- 3.3.19225.9927

    Here are the default values

    AUDIT_USER_ID = ('-1')
    AUDIT_DATE = (getdate())


    · Share on Twitter
  • Options
    sasankjsasankj Posts: 23 New member
    Any advice please?
    · Share on Twitter
  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    Hi, thank you for your replies.

    Using V3.3.19233.10102 of SCA VS (SQL Change Automation Visual Studio extension), I am unable to replicate the fault symptoms.

    Would it be possible to obtain a copy of your Visual Studio Project to see if I can replicate the problem?

    Many thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • Options
    sasankjsasankj Posts: 23 New member
    I can send you the project but you would need DB as well...if I am not wrong....I am afraid I cannot share the DB as it is classified as sensitive DB and cannot be shared.
    · Share on Twitter
  • Options
    Eddie DEddie D Posts: 1,781 Rose Gold 5
    Hi, thank you for your reply.

    A support ticket has been created for you and I have replied to you via the support ticket with a further request.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.