Data Puppy Lite

Database migration is a complex operation, due to incompatibility issues between different platforms. The challenges you, as a database administrator, are facing require a dedicated migration tool that can provide support for secure schema and script conversions, as well as the relocation of the database contents.

Aiming to provide a simple preview of Cirro's main product, Data Puppy Lite promises to help you migrate from one database platform to another without too much trouble. It comes with full support for some of the most widely used database systems, namely MySQL, SQL Server, PostgreSQL, and Oracle.

Its limitation is that it executes tasks serially, which usually puts high stress over a shared network, although it might work fine for local databases. As an alternative, Cirro's Data Puppy is multi-threaded, which means it can handle all the stages of the migration operation much easier, with low impact on a system's resources.

Designed with ease of use in mind, Data Puppy Lite displays a one-window interface containing no more than two panels, one for the source database and the other for the target database.

You can select between one of the four supported database platforms and what you should notice is that the default port number is automatically filled in by the application. However, you must fill in the rest of the fields yourself, starting with the name of the database instance, the username, and the password. Once you connect to the database, Data Puppy Lite loads the list of available schemas, enabling you to choose the one you prefer from a drop-down list.

There are two operations you can perform with Data Puppy Lite: to drop and recreate the schema or to truncate and load the new schema. The migration begins with the click of a button.

Ease of use is undoubtedly the utmost feature of Data Puppy Lite, which provides a straightforward means of switching to another database platform. However, its limitations do not recommend it for large databases.