What are the challenges you face when working across database platforms? Take the survey
Options

Issue with tables with linked data

instalectualinstalectual Posts: 20 Bronze 1
edited July 22, 2014 7:01AM in SQL Compare 11
Is there a formal way to report bugs with the beta? I have encountered an issue where the insert for tables with linked data just tries to insert the first row of data for every row. The script is aware of the number of rows to insert, but it only generates the insert for the first row.

Here is an example:
PRINT(N'Add 7 rows to [active].[lk_Application]')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')
INSERT INTO [active].[lk_Application] ([ApplicationId], [Name]) VALUES (0, N'other')

Comments

Sign In or Register to comment.