Data Compare Missing A Column
natest
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.
TIA
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.
TIA
This discussion has been closed.
Comments
Is the jobecode column also an int datatype in the second database?