Replaying SQL Server Trace for SqlBulkCopy Command

replay rml sqlbulkcopy sql-server trace

Question

We are using RML Utilities (Ostress.exe) for replaying our trace workload, recently we found a query (insert bulk) - [1] in that trace file which is failing to replay since the data being inserted is not present in the captured trace file. After investigation we found out that SqlBulkCopy command is being fired by our application which streams the data to SqlServer and is responsible for the insert bulk statements in the trace file captured. Is there something (capture some specific event, column in trace definition) that we can do to capture the data or replay the trace?

Please let us know if you need more information on the same.

Thanks.

[1] insert bulk X_Table ([GeographyMapping_GeoId] NVarChar(100) COLLATE 
SQL_Latin1_General_CP1_CI_AS, [GeographyMapping_ShapeId] NVarChar(255) COLLATE 
SQL_Latin1_General_CP1_CI_AS, [GeographyMapping_ShapeIndex] NVarChar(255) COLLATE 
SQL_Latin1_General_CP1_CI_AS, [GeographyMapping_Latitude] Float, [GeographyMapping_Longitude] 
Float, [GeographyMapping_Type] NVarChar(100) COLLATE SQL_Latin1_General_CP1_CI_AS)

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why