Rating: No reviews yet
Downloads: 1187
Released: Apr 28, 2013
Updated: Apr 28, 2013 by cgsouthey
Dev status: Stable Help Icon

Recommended Download

Application SQLFile as install script
application, 263K, uploaded Apr 28, 2013 - 324 downloads

Other Available Downloads

Application SQLFile as Assembly Manager library
application, 183K, uploaded Apr 28, 2013 - 145 downloads
Application SQLFile as raw dll
application, 103K, uploaded Apr 28, 2013 - 137 downloads
Documentation Documentation in HTML format (zipped)
documentation, 563K, uploaded Apr 28, 2013 - 95 downloads
Documentation Documentation in PDF format
documentation, 570K, uploaded Apr 28, 2013 - 486 downloads

Release Notes

SQLFile extends and enhances your T-SQL programming environment by exposing the full range of .NET Framework file & directory management functions - and adds the ability to directly import and export data, and to compress both binary and text data stored internally in the database.

SQLFile has 117 functions and stored procedures, including:
  • 8 functions for importing and exporting data between databases and the file system.
  • 9 functions for compressing / decompressing data, converting between encodings and converting between binary, base64 and hexadecimal representations of large binary objects.
  • 4 functions for retrieving directory contents listings - with optional recursion.
  • 17 functions for file and directory path name manipulation - including generating temporary and random, cryptographically secure file & directory names.
  • 8 functions for copying, moving, deleting, replacing, encrypting, decrypting & checking the size of files.
  • 33 functions for checking and setting file attributes and timestamps.
  • 7 functions for creating, deleting, moving and checking directories.
  • 2 functions for checking and setting directory timestamps.
  • 11 functions for checking and setting files access and audit rules.
  • 8 functions for retrieving drive and volume information such as available free space.

Most of the file operations are implemented as scalar functions that can be applied to tables of files etc. so that many files can be read, written or updated in parallel with a single statement.

Reviews for this release

No reviews yet for this release.