Showing posts with label sql table zip. Show all posts
Showing posts with label sql table zip. Show all posts

Wednesday, July 13, 2016

SqlTableZip is now known as - "SQL Server Query Zipper"

I think names are important. And product names specifically should indicate something about the actual product.

With that in mind, "SQL Server Query Zipper" (or SQL Query Zipper in short) does a better job on explaining what the tool does - even before reading the description.

There's a new version - which in addition to other enhancements, also goes by the new name.

TA-DA!



The console version was also renamed and the executable is now called: SSQZConsole

Monday, June 22, 2015

New version for SQL Table Zip

There's a new version for SQL Table Zip!

SqlTableZip is a SQL Data Export/Import tool, which allows you to backup any query result (so - from a single table to a complex query) into a proprietary compressed file (.SQZ)

The app fills the gap between existing solutions:
- SQL Server backup: is for database-level only
- File Import/Export: usually comes in an uncompressed flavor, and requires various steps both in the export and the import processes (such as defining delimiters, data types, column headers and more)

Instead, SqlTableZip lets you send any data to a compressed file in a single click, and retrieve it quickly and transparently later.



Here are some of the changes for the current version:

- SQL Server 2016 support
- Improved table picker (more info, improved sorting, requires less permissions)
- Changed help HTML renderer, fixed display
- Core library updated
- Help redesigned (also - switched back to default renderer)

Claim your copy: http://www.doccolabs.com/products/sqltablezip


Monday, June 30, 2014

Announcing - products are out of beta, available for purchase.

After a lot of hard work, the beta 'incubation' period is finally over.
We are excited to announce new & exciting versions for all of our products!

The products available for purchase are:

  • ClipTable (Turn *any* tabular data, from any source to a SQL Table in seconds!)
  • Database File Explorer (Get a clear picture of how your databases consume your storage space)
  • SQL Table Zip (Our new query-to-go packer - turn any table or SQL Query into a compressed [.sqz] file)
  • Log Table Viewer (Add logging to your stored procedures, along with a powerful real-time viewer)
  • And as always - SQL Stripes, which is on sale for a limited time: $799 (instead of $1,250)
Each product can be purchased separately, or as a bundle - in a new attractive offer. (see more details at doccolabs.com/purchase)


















We are also pleased to present our redesigned website, hope you all like it.


Wednesday, April 9, 2014

Introducing: SQL Table Zip



Today we're introducing a new product which enables you to perform a very simple task:

Backup any table/sql statement into a compressed file.

While many already figure out the huge benefit just be reading the line above, here's some more detailed info:

When you have to send a table over (and let's suppose it's a big one, with a lot of columns/rows), there are various ways of getting the task done, but every one has its downsides. Here are some examples -

- bcp (in/out) - while being quite fast, bcp utility has quite a few limitations, lacks the table schema definition and takes up a lot of space. You will have to perform multiple steps both in the "backup" and the "restore" sides.
- csv/txt export - where should I begin... delimiters hell, missing schema (can include headers but no datatypes)

- ssis - very useful when you have a connection to both ends. otherwise, you would face the same issue on how to save the output (csv, tsv etc...)

- database backup - the name implies the problem; It backs up the entire database. Of course, you can create another empty database and start moving your tables but this creates a great overhead, takes up extra space (both the database files & the backup size) and requires the "restoring" user to actually have this database created and then take the table out of it.

The reasons above (and there are quite a few more) were the main objective of writing SqlTableZip; a product that solves this problem.

Think about it - next time you want to backup/pack/send some data over, simply write your select statement, click "Backup", take that .SQZ file anywhere and restore to any server/database you like, under any name you wish.

So, ready to try it out?
The 1st beta is out, free to use.

http://www.doccolabs.com/products_sqltablezip.html