Options

ScriptFile output missing primary key column values

WyrusWyrus Posts: 3 New member
in SQL Data Compare
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!!!

Tagged:
· Share on Twitter

Best Answer

Answers

Sign In or Register to comment.