ScriptFile output missing primary key column values

Wyrus

I'm using SQL Data Compare v13.4.5.6953 against SQL 2008 R2

I'm using SQL Data Compare via command-line to create a script to populate a table. The table definition is this...

<div>CREATE TABLE [dbo].[AlarmCategory]</div><div>(</div><div>[AlarmCategoryId] [int] NOT NULL,</div><div>[AlarmCategoryName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,</div><div>[Enabled] [bit] NOT NULL</div><div>) ON [PRIMARY]</div><div>GO</div><div>ALTER TABLE [dbo].[AlarmCategory] ADD CONSTRAINT [PK_AlarmCategory] PRIMARY KEY CLUSTERED&nbsp; ([AlarmCategoryId]) ON [PRIMARY]</div>

Now, when I run SQLDataCompare with a command-line like this:

SQLDataCompare /server1:<server> /database1:<db> /scripts2:<folder-name> /Synchronize /options:None /include:Table:AlarmCategory<br>

The generated file contains lines including the primary key column. For instance...

<div>INSERT INTO [dbo].[AlarmCategory] ([AlarmCategoryId], [AlarmCategoryName], [Enabled]) VALUES (1, N'Health/Safety', 1)</div><div></div>

However, when I attempt to create a single script file like this:

SQLDataCompare /server1:<server> /database1:<db> /empty2 /scriptfile:<filename> /options:None /include:Table:AlarmCategory<br>

The generated file does not include the primary key column. For instance...

INSERT INTO [dbo].[AlarmCategory] ([AlarmCategoryName], [Enabled]) VALUES (N'Health/Safety', 1)

I kinda need that column.

Any ideas?

Thanks!!!

squigley

Can you confirm if you're still getting this issue on the latest version of SQL Compare?

https://documentation.red-gate.com/sc13/release-notes-and-other-versions/sql-compare-13-7-release-notes

Wyrus

In case I stated it poorly... Saving to a Scripts folder does the right thing, but saving to a single script file does not.

Russell D

This looks like it could be SDC-2884, which is listed as fixed but I'll dig into it.

Wyrus

I just updated to v13.7.3 and it appears to work correctly. Thanks!