sql azurems excel

SQL Azure to MS Excel Migration

A handy converter that is created to simplify as much as possible the process of data migration  from MS Excel spreadsheets (.xls and .xlsx formats) to SQL Azure database and back from SQL Azure database to MS Excel sheets (.xls and .xlsx files) .

 It allows you to convert the entire MS Excel file or select only definite ranges of data from Excel spreadsheet to create as many tables as you need for generating SQL Azure database. And inversely each SQL Azure table is moved to one Excel sheet. 

The application gives you an opportunity to adapt destination db to your needs. Before creating your database, you can visualize it in the configurable tree-view and change it using a large number of customizable settings.

You can move your data just in few easy steps. The user interface is quite simple, streamlined and very easy to understand.

All data transferring can be performed from built-in scheduler so the conversion and synchronization of the databases will happen automatically.  

Use this software for converting and synchronizing your databases quickly and accurately. Get the most correct upload output.

Read here trial versions limitations

Product highlights

Requirements

  • Necessary privileges to write into network shared folder (LAN or VPN) where destination database Excel resides
  • Microsoft Visual C++ 2008 x86 Redistributable package
SQL Azure MS Excel

Converter from
SQL Azure to MS Excel

  • 15 Jan, 2013
  • Version 1.3.6
ORDER From $149 DOWNLOAD 17.12 Mb

Two-way database migration in one package. Pay once - get both! Find more information about the reverse migration

From MS Excel to SQL Azure

New Features

  • Speed improvement for better conversion allows converting large databases with nearly 500 thousand records in 30-40 min.
  • Variable quantization step added.

Screenshots

Database conversion / synchronization features

  • 1 - Workaround for firewalls and access rights
  • 2 - Views conversion
  • 3 - Flexible customization for all db elements
  • 4 - Bulk and quantization for speed up of big volume of data processing
  • 5 - Conditional data migration
  • 6 - Full UNICODE architecture support
  • 7 - Optimal data mapping
  • 8 - Verification of potential migration issues
  • 9 - Command line mode & scheduling
  • 10 - Savable sessions