SQLFile

Direct file access & data import / export from within MS SQL Server scripts
Download

SQLFile Ranking & Summary

Advertisement

  • Rating:
  • License:
  • Trial
  • Publisher Name:
  • TotallySQL Ltd
  • Operating Systems:
  • Windows XP / Vista / Vista64 / 7 / 7 x64
  • File Size:
  • 182 KB

SQLFile Tags


SQLFile Description

Edit By 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.


SQLFile Related Software