Data Removal, Archiving and Structure


Move text data from column to file - Extract large text columns to individual files and replace the original value with a URI for the extracted file.

Hierarchical Data Deletion/Archiving - Two methods of deleting data involved in PK/FK relationship. One by disabling the constraints and the other by traversing the constraint hierarchy.

Generate BCP Format Files - Dynamically generate BCP format files given the Table Name and Delimiter.

Generate Data Insert Statements - A common task with protection against special characters by using hex encoding to script out string contents.

Generate Hierarchical Table Listing - An alternative implementation of the generation of a hierarchical list of tables for use in data deletion