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.

Native Look and Feel

All TotallySQL Transact-SQL extensions are implemented using familiar programming objects within SQL (scalar and table-valued functions and stored procedures) , keeping the syntax clean and making them as fast and easy to use as built-in functions.