Data Compare Missing A Column

natestnatest Posts: 3
I have a simple table definition (as seen by SQL Compare):

CREATE TABLE [dbo].[jobcodes]
[Jobcodeid] [int] NOT NULL IDENTITY(1, 1),
[jobecode] [int] NOT NULL,
[JobcodeDesc] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

I wanted to synch the data in this table between two databases. Data Compare's script came out looking like:

INSERT INTO [dbo].[jobcodes] ([Jobcodeid], [JobcodeDesc]) VALUES (1, N'Administrative Services- Entry')

Notice that the script does not include the "jobecode" column. And since this column cannot be null, the script fails.

I was wondering if anyone could tell me why this column is not being included in the script.



This discussion has been closed.