Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 14 in printed book and digital formats -- plus a one-year subscription so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

PDF:

Review

SQLite Migrator

Issue: 8.1 (November/December 2009)
Author: Dave Mancuso
Article Description: No description available.
Article Length (in bytes): 3,507
Starting Page Number: 11
RBD Number: 8104
Resource File(s): None
Related Link(s): None
Known Limitations: None

Full text of article...

IN BRIEF
 
Product
SQLite Migrator
 
Manufacturer
LogicalVue Software
 
Price
$49.95
 
Contact Info
http://www.logicalvue.com/sqlite/sqlite.html
 
Pros
Quick, simple, clean, effective
 
Cons
None to speak of
 
Rating (1.0-5.0):
4.5

SQLite Migrator, from LogicalVue Software, is essentially a one-stop shop for conversion of databases into SQLite format. What kinds of databases? SQLite will transform, Access, FoxPro, MySql, Postgresql, MS SQL, and the list goes on. The reason that SQLite Migrator is such a Swiss Army knife kind of tool is that it can connect to any database format that makes use of ODBC for connections. The possibilities for this are very impressive. If a client wants you to remake an old database for them, and the database is in Access, you're not too far away from a quick magic trick. Convert the database to SQLite with SQLite Migrator and you can start building something in REALbasic right away. This could be very handy when you need something quick.

Installing the app is pretty standard on Mac OS and Windows using the standard installers. I installed the application on both Mac OS (Snow Leopard) and Windows 7 (where the installation took less than six seconds). The interface is pretty simple, with buttons (and corresponding menu commands) to selects a database source and destination. On OS X, I couldn't get the Source DB command to open a dialog box, either an issue with Snow Leopard or an issue with my own machine. On Windows 7, the dialog box opened with no problems. Choosing commands was a bit slow but not bad, probably a Windows 7 issue (I'm using the beta).

Converting a database took a few steps, but went well. The PDF documentation, found in the SQLite Migrator application folder, is invaluable for running through the process the first time. Note that in Windows this application folder is in the C drive's Program Files directory. I set up the ODBC data source using the Windows ODBC Administrator Control Panel for my test database, and then used SQLite to convert the database to SQLite. The original database was left untouched, always a good thing. The new SQLite database was cleanly made and worked fine. Essentially, that was it. SQLite Migrator worked, and it worked simply, quickly, and accurately.

LogicalVue has an online support site, and I noticed a few features targeted for future versions, mostly enhancements in how primary keys, indexes, views, and tables are handled. The developer (Paul Lefebvre) has an active blog and online presence, a key necessity for an application of this nature. The application is priced at $49.95, and in demo mode will convert the first three tables and ten rows of a database. That's certainly enough to test a few databases for conversion in your own situation. SQLite Migrator promises to be a valuable tool in a developer's programming arsenal.

End of article.

Article copyrighted by REALbasic Developer magazine. All rights reserved.


 


|

 


Weblog Commenting and Trackback by HaloScan.com