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
To learn more and of course get the software, visit our website @ www.doccolabs.com
