Friday, June 8, 2012

Cyber-D’s SQL Wizard 2.01

Cyber-D's SQL wizard makes it easy to generate SQL queries from CSV data. This tool is ideal for people who need to insert large amounts of data into an SQL database. If you always receive Excel documents and need to insert the data into an SQL database, then this tool is ideal. Simply save the Excel document as a Comma Separated Value, import the file, change the variables (see video tutorial on product's website), click parse and save as SQL file. Now you can import the file in your SQL database.

  1. Export the Excel document as a CSV file (where “;” is used as a separator).
  2. Run SQL Wizard and browse for the csv or txt file.
  3. Give the columns in the CSV a unique identifier in the “CSV Column identifiers” field. You can use any name you like, as long as it’s between the [square brackets] and seperated by a semicolon. These variable names represent the columns of the CSV document in the same order.
  4. Modify the “SQL Insert Query” field to match your table name and table field names. Use the CSV Column identifiers you entered as values. 
  5. Click on “Parse” to generate the SQL Queries.
  6. Click on “Save as SQL” to save the SQL query on your desktop.
  7. Open the SQL file for inspection and load into SQL database when satisfied.
This tool can also be used to create any other type of queries if you modify the SQL Insert Query string to your needs.
A great alternative for my SQL Wizard is Exportizer. It has a lot more functions, processes data faster and supports more database formats.

However, if you have the money and if you want to make your life working with remote databases A LOT easier, then please for the sake of sanity take a look at NaviCat