Pages

Saturday, 19 January 2013

DBConvert for SQLite & MySQL

DBConvert for SQLite & MySQL provides two-way conversion from SQLite databases to MySQL server and from MySQL to SQLite. If your hosting provider restricts direct access to your MySQL database you may create PHP script or Dump files to workaround any restrictions. Unicode Support and Primary keys and Indexes conversion are available.
DBConvert for SQLite & MySQL is a reliable bi-directional database migration tool which allows you to convert from:
- SQLite to MySQL
- SQLite to MySQL Dump
- SQLite to PHP Script
- SQLite to SQLite
- MySQL to MySQL
- MySQL to MySQL Dump
- MySQL to PHP Script

Main Features:
- Interactive (GUI) mode / command line mode;
- Saving data into a MySQL Dump and PHP script for export to MySQL database;
- SQLite version 3.0 and higher support;
- SQLite database size optimization;
- Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for DBMS internal purposes) with a substitute symbol;
- Automation of the conversion process with task planner scheduler;
- Ability to select ISAM, MYISAM, HEAP, InnoDB or BDB table types when copying data to MySQL or MySQL Dump;
- Unicode Support/Connection character sets support:
LATIN1, LATIN2, LATIN5, LATIN7, ARMSCII8, ASCII, CP1250, CP1251, CP1256, CP1257, CP850, CP852, CP866, DEC8, GEOSTD8, GREEK, HEBREW, HP8, KEYBCS2, KOI8R, KOI8U, MACCE, MACROMAN, SWE7, TIS620, UTF8 (unicode charset);
- Primary keys and Indexes support ;
- Foreign keys (relations) support;
- Advanced customization options:
- partial selection for database objects to be converted;
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
- Sessions support - all your settings can be saved and restored then.
- `ENUM` and `SET` MySQL database types support;
- ‘Binary picture` SQLite data types support;
- Ability to connect to MySQL database servers located on all Unix-like and Windows machines.
- Skins support;
- 1-year free upgrades.

Requirements:
- Windows 7/Vista/XP/2000/NT (NT only with Internet Explorer 4.01)
- At least 32 MB of RAM
- Necessary privileges to write into database on the target MySQL server (this requirement is optional as there is an option to overcome the restrictions using dump file or PHP Script )

from www.dbconvert.com