Baseline script giving errors

sasankj

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"

Eddie D

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

sasankj

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())

sasankj

Any advice please?

Eddie D

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

sasankj

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.

Eddie D

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