Tuesday, September 9, 2014

Your new data Import-Export power tools


If you’re working with databases, you are obviously no stranger to the endless need for getting data in and out the database. And not only the traditional inserts and selects, but rather importing from/exporting to “foreign” sources.

Two of our tools are just around that area and can pretty much solve any scenario of import/export you may come across!

How?

Well, the first tool, SqlTableZip can export a data from any query (table, stored procedure execution result, free t-sql) into a compressed file - Which includes the query text, headers, field types, and of course, the data - highly compressed!





This (.sqz) file, can be moved around and restored anywhere. Supporting multiple SQL Server versions, including Azure (so in fact, it is also a very easy way to get data in & out between Azure and local SQL Instances)
DBA’s sending production-data to developers (who don’t have access), Field engineers bringing offline data for analysis/support purposes, or even a simple table-level backup -- these are all valid scenarios that SqlTableZip can take care of; easily, quickly and with zero-hassle.
There are no size limits. You can backup huge amount of data and everything runs super-fast.

So, getting data in & out of SQL Server is covered, but what about data some comes from foreign sources?

If your source is a table coming from anything like html formatted tables, xml, excel, pdf, word and pretty much any other tabular format that needs to be turned into a relational-database table: ClipTable is here to help!
Instead of supporting each of the formats above (and many more) - we took a different approach by building a smart algorithm that can analyze the content you copy into your clipboard.



So the process becomes very simple - you select the desired content, paste it into ClipTable and get a new table ready to be created.
ClipTable will determine the correct format, the best field data types, column names and the correct row/col delimiters. All of these are automatically done and all that is left for you, the user, is to decide where you would like the new table to be created.

As a bonus - ClipTable supports most of the popular relational databases out there today - so you can create your new table/s in SQL Server, Oracle, MySQL, PostgreSQL and Firebird.

So, to summarize: if data import/export is part of your routine, this is definitely worth trying.
To learn more and of course get the software, visit our website @ www.doccolabs.com