Yesterday, SQLite Migrator 1.2.0 was released.
SQLite is a great database engine, but migrating to it brings some hassles. With SQLite Migrator, it’s a simple 3 step process to migrate from nearly any database to SQLite:
- Select your Source Database
- Select the destination SQLite database
- Click Migrate
That’s it. There are a few options you can tweak such as the source database encoding and whether to create accompanying text files for the SQL CREATE TABLE commands and source data.
It’s fast and easy! We have customers using SQLite Migrator to migrate data from FoxPro, Access, Firebird, MySQL and many other databases.
And even if you’re not looking to migrate to SQLite, there is another very useful thing it can do for you: Backups. Because it copies the database, you effectively have a full backup of your database schema and data as a SQLite file.
This can be handy if you want to take a copy of the database to work with it offline. You can simply connect instead to this SQLite database and run your tests, create your reports or do whatever you need without worrying about messing up the database on the server.
Give it a try today! As a special deal for readers of this blog, here is a coupon for $10 off at our online store, good through March 22, 2008: CPN4780792959
We’re continuing to update SQLite Migrator regularly. Future planned features include:
- Extract View Source
- Support tables with multi-part keys
- Migrate indexing
- Migrate default values