SQLFile - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

SQLFile by TotallySQL

URLs: sqlfile, totallysql

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.

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

External file and directory access with data import/export and compression.

Pricing: SQLFile - CAL (Client Access License) V1.0 1 CAL License, SQLFile - CAL (Client Access License) V1.0 5 CAL License, SQLFile - CAL (Client Access License) V1.0 10 CAL License, SQLFile - CAL (Client Access License) V1.0 25 CAL License, SQLFile - CAL (Client Access License) V1.0 50 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 1 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 5 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 10 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 25 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 1 Year Support & Maintenance 50 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 1 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 5 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 10 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 25 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 3 Year Support & Maintenance 50 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 1 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 5 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 10 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 25 CAL License, SQLFile - CAL (Client Access License) V1.0 with - 5 Year Support & Maintenance 50 CAL License, SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 1 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 3 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal 1 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal 5 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal 10 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal 25 CAL Support & Maintenance Renewal License, SQLFile CAL (Client Access License) - 5 Year Support & Maintenance Renewal 50 CAL Support & Maintenance Renewal License, SQLFile - CPU License V1.0 1 CPU License, SQLFile - CPU License V1.0 2 CPU License, SQLFile - CPU License V1.0 4 CPU License, SQLFile - CPU License V1.0 8 CPU License, SQLFile - CPU License V1.0 Unlimited CPU License, SQLFile - CPU License V1.0 with - 1 Year Support & Maintenance 1 CPU License, SQLFile - CPU License V1.0 with - 1 Year Support & Maintenance 2 CPU License, SQLFile - CPU License V1.0 with - 1 Year Support & Maintenance 4 CPU License, SQLFile - CPU License V1.

Evals & Downloads: Read the SQLFile help file, Read the TotallySQL License Agreement, Download the SQLFile V1.0 evaluation on to your computer - Expires After 30 Days

Operating System for Deployment: Windows 7, Windows Server 2008, Windows Server 2003

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET Class, 100% Managed Code

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005

Keywords: SQLFile

totally sql

File Handling

compression java, compression c#, compression library, compression c++, compression control, compression vb, compression class, compress library, compression delphi, compression component, compression unzip, compression activex, compression dll

SQL query language

Part numbers: PC-541762-407491 541762-407491 PC-541762-407492 541762-407492 PC-541762-407493 541762-407493 PC-541762-407494 541762-407494 PC-541762-407495 541762-407495 PC-541762-407496 541762-407496 PC-541762-407497 541762-407497 PC-541762-407498 541762-407498 PC-541762-407499 541762-407499 PC-541762-407500 541762-407500 PC-541762-407501 541762-407501 PC-541762-407502 541762-407502 PC-541762-407503 541762-407503 PC-541762-407504 541762-407504 PC-541762-407505 541762-407505 PC-541762-407506 541762-407506 PC-541762-407507 541762-407507 PC-541762-407508 541762-407508 PC-541762-407509 541762-407509 PC-541762-407510 541762-407510 PC-541762-407511 541762-407511 PC-541762-407512 541762-407512 PC-541762-407513 541762-407513 PC-541762-407514 541762-407514 PC-541762-407515 541762-407515 PC-541762-407516 541762-407516 PC-541762-407517 541762-407517 PC-541762-407518 541762-407518 PC-541762-407519 541762-407519 PC-541762-407520 541762-407520 PC-541762-407521 541762-407521 PC-541762-407522 541762-407522 PC-541762-407523 541762-407523 PC-541762-407524 541762-407524 PC-541762-407525 541762-407525 PC-541762-407771 541762-407771 PC-541762-407772 541762-407772 PC-541762-407773 541762-407773 PC-541762-407774 541762-407774 PC-541762-407775 541762-407775 PC-541762-407776 541762-407776 PC-541762-407777 541762-407777 PC-541762-407778 541762-407778 PC-541762-407779 541762-407779 PC-541762-407780 541762-407780 PC-541762-407781 541762-407781 PC-541762-407782 541762-407782 PC-541762-407783 541762-407783 PC-541762-407784 541762-407784 PC-541762-407785 541762-407785 PC-541762-407786 541762-407786 PC-541762-407787 541762-407787 PC-541762-407788 541762-407788 PC-541762-407789 541762-407789 PC-541762-407790 541762-407790 PC-541762-407791 541762-407791 PC-541762-407792 541762-407792 PC-541762-407793 541762-407793 PC-541762-407794 541762-407794 PC-541762-407795 541762-407795 PC-541762-407796 541762-407796 PC-541762-407797 541762-407797 PC-541762-407798 541762-407798 PC-541762-407799 541762-407799 PC-541762-407800 541762-407800 PC-541762-407801 541762-407801 PC-541762-407802 541762-407802 PC-541762-407803 541762-407803 PC-541762-407804 541762-407804 PC-541762-407805 541762-407805