SQLCompress.NET provides two “out of the box” implementations based on Microsoft .NET Framework 2.0 compression classes. You can add compression to your databases without changing your applications, verify compressed data, reduce database footprint, and improve bandwidth usage. You could even extend SQLCompress.NET to use your own libraries!

• A basic implementation (that does not compress data) for extensibility, troubleshooting and benchmark purposes
• A Deflate implementation using Microsoft .NET 2.0 System.IO.Compression.DeflateStream
• We also added a GZip implementation using Microsoft .NET 2.0 System.IO.Compression.GZipStream.

Just to make things better, SQLCompress.NET provides the BaseImplementation class that can be extended to use other compression algorithms or libraries.

Getting more out of your infrastructure

SQLCompress.NET can compress columns with minimum performance impact. Compression can be applied to the following data types:

• TEXT
• NTEXT
• IMAGE
• VARBINARY(MAX)
• VARCHAR(MAX)
• NVARCHAR(MAX)
• VARCHAR(N)
• NVARCHAR(N)
• VARBINARY(N) 

This could reduce database footprint without impacting performance. Another benefit comes when replicated columns are compressed. Replication is bandwidth intensive and SQLCompress.NET can reduce bandwidth utilization and improve throughput by reducing the amount of data to be replicated.