Forum Discussion

Pattison159's avatar
Pattison159
Copper Contributor
Aug 25, 2023

Database schema question

In Visual Studio 2022 i am running the comparison tool to compare two databases schema.

 

So far after the analysis it "seems" all is ok as the column between tables all have ticks (with blue background) but when i select a table, i see red highlights on a column or two which is similar to (i will list the red highlights rather than paste the entire table columns for brevity)

 

Original Database 

[updated] DATETIME CONSTRAINT [DF_customKeyValue_updated] DEFAULT (getDate()) NOT NULL,

 

Compared database

[updated] DATETIME CONSTRAINT DEFAULT (getDate()) NOT NULL,

 

Majority of the tables have the exact same red highlight along with similar declarations as CONSTRAINT [DF_tableName_columnName].

 

Is this of some concern? Should i be ok to ignore these errors and assume these are very mild differences and wont affect anything? Or should they have to be applied?

 

No RepliesBe the first to reply

Share