SQLFile
by TotallySQL - Product Type: Component / .NET Class / 100% Managed Code
External file and directory access with data import/export and compression. 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 functions include: read & write binary, text & delimited files (e.g. CSV); check for, create, move, copy & delete files & directories; encrypt & decrypt files; compress & decompress file images in the database; manage file access & audit rules; check & alter file attributes; get disk information.
Our regular prices are shown below. Please logon to see your discounted prices.
SQLFile - CAL (Client Access License) V1.0
SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance
SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance
SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance
SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal
| Add to Cart |
$ 29.20 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 97.80 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 156.60 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 293.80 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 489.80 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal
| Add to Cart |
$ 58.41 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 195.61 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 313.21 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 587.61 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 979.61 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal
| Add to Cart |
$ 87.61 |
1 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 293.41 |
5 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 469.81 |
10 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 881.41 |
25 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 1,469.41 |
50 CAL Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
SQLFile - CPU License V1.0
| Add to Cart |
$ 2,449.02 |
1 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 3,919.02 |
2 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 5,879.02 |
4 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 9,795.10 |
8 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 15,674.12 |
Unlimited CPU License |
|
Download (474 KB) |
SQLFile - CPU License V1.0 with - 1 Year Support & Maintenance
| Add to Cart |
$ 2,938.82 |
1 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 4,702.82 |
2 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 7,054.82 |
4 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 11,754.12 |
8 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 18,808.94 |
Unlimited CPU License |
|
Download (474 KB) |
SQLFile - CPU License V1.0 with - 3 Year Support & Maintenance
| Add to Cart |
$ 3,428.63 |
1 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 5,486.63 |
2 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 8,230.63 |
4 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 13,713.14 |
8 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 21,943.77 |
Unlimited CPU License |
|
Download (474 KB) |
SQLFile - CPU License V1.0 with - 5 Year Support & Maintenance
| Add to Cart |
$ 3,918.43 |
1 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 6,270.43 |
2 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 9,406.43 |
4 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 15,672.16 |
8 CPU License |
|
Download (474 KB) |
| Add to Cart |
$ 25,078.59 |
Unlimited CPU License |
|
Download (474 KB) |
SQLFile CPU License - 1 Year Support & Maintenance Renewal
| Add to Cart |
$ 489.80 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 783.80 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 1,175.80 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 1,959.02 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 3,134.82 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
SQLFile CPU License - 3 Year Support & Maintenance Renewal
| Add to Cart |
$ 979.61 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 1,567.61 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 2,351.61 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 3,918.04 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 6,269.65 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
SQLFile CPU License - 5 Year Support & Maintenance Renewal
| Add to Cart |
$ 1,469.41 |
1 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 2,351.41 |
2 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 3,527.41 |
4 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 5,877.06 |
8 CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
| Add to Cart |
$ 9,404.47 |
Unlimited CPU Support & Maintenance Renewal License |
Verify |
Download (474 KB) |
Our prices include ComponentSource technical support and, for most downloadable products, an online backup and a FREE upgrade to the new version if it is released within 30 days of your purchase. All sales are made on our standard Terms and Conditions and subject to our Return Policy. Please contact us if you require any licensing option not listed, including volume licensing and previous versions.
Our regular prices are shown above. Please logon to see your discounted prices.
SQLFile has 110+ functions and stored procedures, including:
- Functions for importing and exporting data between databases and the file system.
- Functions for compressing / decompressing data, converting between encodings and converting between binary, base64 and hexadecimal representations of large binary objects.
- Functions for retrieving directory contents listings - with optional recursion.
- Functions for file and directory path name manipulation - including generating temporary and random, cryptographically secure file & directory names.
- Functions for copying, moving, deleting, replacing, encrypting, decrypting & checking the size of files.
- Functions for checking and setting file attributes and timestamps.
- Functions for creating, deleting, moving and checking directories.
- Functions for checking and setting directory timestamps.
- Functions for checking and setting files access and audit rules.
- 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.
SQLFile Features
- Read, write & update multiple files & directories in parallel
- Read entire file contents as single scalar binary or text values
- Read text file contents as single-column tables (1 row per line)
- Read & parse character-delimited text files as multi-column tables
- Export single scalar binary or text values as whole files
- Append scalar text values to existing files
- Write character-delimited text files directly from tables, view or ad-hoc queries
- Compress / decompress text or binary values within the database for more efficient storage
- Create cryptographically secure unique random file & directory names
- Create uniquely-name temporary files in the system temporary folder
- Retrieve directory contents listings as single or multi-column tables - with optional recursion
- Encrypt or decrypt files in the file system
- Copy, move, replace, delete, & check the existence & size of files
- Create, move, delete, check for existence of & get parent or root of directories
- Read or set file attributes (e.g. readonly, hidden, system, archive, temporary, offline, compressed, encrypted)
- Read or set timestamps on files and directories (created, last accessed, last written)
- Check, create, alter, remove or purge access and audit rules for files and directories
- Compress / decompress scalar binary and text values
- Convert large binary objects between their binary, Base64 text and Hexadecimal text representations
- Convert text file contents between different code pages / encodings
- Retrieve drive type, volume, format, readiness, available free space, total free space & size information
- Parse file path strings to retrieve directory name, file name, file extension, root folder information
- Easily alter & combine path strings & test for validity (without accessing the file system)
- Return as a table a list of logical drives on the server
;)