search cancel

MSSQL Subset Insert scripts

book

Article ID: 230118

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

There are two identified issues with the script
 
1)     The line 1 “use” statement by default references the TARGET.   It must reference the SOURCE for the script to work properly

2)     The Informational message printed out after each Insert regarding the number of rows inserted to the table shows zero rows when referencing a Table with Identity.    The script line must be moved prior to the SET IDENTITY INSERT OFF statement, otherwise the @@ROWCOUNT gets zeroed out.    In the screenshot below, line 21 MUST be moved to before line 19 in order for the accurate @@ROWCOUNT to be generated to the log / standard out.   This is a general case only for those tables that have an IDENTITY column, where the script includes the ON and OFF statements.

Environment

Release : 4.9.1

Component : Subset

Cause

Defect

Resolution

Download and install the latest subset patch build compatible with TDM 4.9.1 from below link:

https://support.broadcom.com/external/content/release-announcements/Test-Data-Manager-TDM-Patches/16649