GT Subset - SQL Server Import Export Script Suggested Enhancements

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Export old
bcp "CDD.dbo.Address" out "Address.dmp" %GTCONNECT% %GTSERVER% -w -k -q -CRAW -o Address_export.log
Export new
bcp "CDD.dbo.Address" out "Address.dmp" %GTCONNECT% %GTSERVER% -o Address_export.log -t"[||]" -w -k -q -CRAW
Import old
bcp "%GTDATABASE%.%GTOWNER%.Address" in "Address.dmp" %GTCONNECT% %GTSERVER% -w -k -q -E -b1000000 -CRAW
Import new
bcp "%GTDATABASE%.%GTOWNER%.Address" in "Address.dmp" %GTCONNECT% %GTSERVER% -e error_Address.recx -m 197000000 -o Address_import.log -t"[||]" -w -k -q -E -b1000000 -CRAW

1. There is trouble determining errors and records rejected and added the -e, the -o parameters to the import. This should be a product default.
2. BCP was stopping after 10 errors. Added the -m to significantly large number to see what errors. This should be optional.
3. The data contained tab characters and therefore disrupted the import. Added the -t. This should be a product default.

Environment

TDM 4.5
Subset

Cause

Rather than manually adding this, the product should have these defaults.

Resolution

Here is the enhancement for list of enhancements.  The patch for this is SUBSET24APRIL2018.zip.  Please check with CA Support to get this version or the latest version for SUBSET.

You can now set the max BCP errors in the generation screen, and it delimits with [||] by default

<Please see attached file for image>

Additional Information

Video URL on how to open a Support Case - https://community.broadcom.com/groups/viewdocument/demo-how-to-update-a-case-with-ca?CommunityKey=c475a143-13f8-4809-b469-d8541b80ea91&tab=librarydocumentshttps://communities.ca.com/videos/5898-demo-how-to-open-a-support-case

To contact support, go to https://support.broadcom.com/