Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
David Lantz: "Thank you, this is by far the simplest, and most friendly utility for building db record system I have ever used. I wish I could get my systems guys at the office to purchase this for our company would be so very helpful and speed up a lot of work. I for one have used it for everything from a simple inventory record of my house, to a members record for my church just little pet projects and a test bed to test my own db builds and theories before having to hand code at the office..... it is a lot of fun to work with".
Ingo Bindbeutel: "I did buy Firebird Maestro before, because it is an excellent application and does a very very good work for me! I tried AnySQL and I did buy it, because it's a wonderful application too! Both are similar to use and easy to work with it! I am impressed by the quality and stability of the product! To all members of the SQL Maestro - Team: "keep going this way and make many people happy in using your software!" Thank you for making my life easier and my work productive".

More

Add your opinion

Customers
SQL Maestro Group / News / All company news / First public release of SQLite Data Wizard

First public release of SQLite Data Wizard

May 1, 2006

Prev Next

We are pleased to introduce SQLite Data Wizard - a powerful utility for managing your SQLite data.

SQLite Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. It allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the SQLite database (i.e. any database for which you have an OLE DB Provider or ODBC driver such as MS Access or Microsoft SQL Server database) with its structure and data, export data from SQLite tables and queries to most popular formats, and import data into the tables.

Product versions are formalized according to their release dates: the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. For more information apply to the corresponding news item. Hence, the present version is 6.5.

While developing the new software product we tried to implement the usable features available in the existing products and provide it with unique functionality. Please consider the short list of SQLite Data Wizard 6.5 main features below:

  • powerful PHP Generator for creating PHP scripts from tables and queries from different databases; full customization of the HTML pages appearance with some standard HTML templates provided for your convenience; full adjustment of the result script: you can enable/disable record filtering, column ordering, adding/editing/deleting records in the result script and many more;

  • Data Pump Wizard implementation: you can convert any local or remote ADO-compatible database with its structure and data to your database in a few mouse clicks; full customization of the target database and objects: you can create a new database or convert it to the existing one, select objects for conversion and specify their properties; adjustable data import from the source tables to the target ones with the ability of viewing and editing the SQL script generated for the database conversion;

  • easy data export operations: SQLite Data Wizard 6.5 provides a powerful tool for exporting data from tables and queries to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX and SQL to different databases with an ability to select fields to be included into the result files and full customization of the result export files: formats, headers/footers, record count, etc. and powerful options for specific customization: full Excel formatting including notes and hyperlinks, RTF formatting, full HTML and PDF appearance adjustment, and more;

  • efficient tools for importing data: SQLite Data Wizard 6.5 provides a powerful tool for importing data into tables from different databases with the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV; easy adjustments of the source file columns and the destination table fields and full customization of the import process for each imported file including data formats for all or selected fields, commit options, number of rows to skip and records to import, etc., the ability to define the key columns for the table and select whether to skip, update or delete the records if their keys value match the imported ones;

  • the Shell Application that provides friendly user interface for working with all the implemented wizards: easy-to-use interface provided by the SQLite Data Wizard will make your work with data fast and highly efficient;

  • support for SQLite Server versions from 2.8 to 3.x.x provided.

 

We hope that you will enjoy working with your SQLite data!


Related links:

Prev Next
Back to news archive