We’ve updated dbCOPY recently! We focused primarily on bug fixes especially concerning SQL Server. As usual, you can download the latest version through our web interface!
There are some great features under the hood of dbCOPY which are a little bit hidden – simply to keep the user interface as clean as possible. One of these features is the conversion from String to Boolean. Of couse, dbCOPY is able to convert typical Strings like “true” or “false” to a Boolean. But what happens if you have a table that contains strings like “correct” and “wrong”?
The solve this case, click on the “Advanced” button on the Table Mapping page.
Next to this blog, our e-mail service, telephone hotline and our GetSatisfaction forum, we would like to announce our Twitter service. Using Twitter we will keep you up-to-date about the current development of dbCOPY. Just click on this small button to follow us on Twitter:
dbCOPY has a little feature that allows you to export data very quickly. Just browse to your database using our integrated viewer, select the cells you want to export and right click on them. The appearing context menu allows you to export those cells very quickly.
dbCOPY is famous for its high-speed data conversions between Paradox and any other supported database system like mySQL or SQL Server. In the following we describe a typical data export from Paradox to mySQL which shows how easy it is to migrate to another DBS with dbCOPY.
1.) dbCOPY starts with a task-oriented, simple interface that offers access to the most heavily used features. In this case we select “Export“. But you could also use features like Update or Append as soon as you have created the table structure (or in case that you would like to transfer data regularly between Paradox and another DBS).
2.) In the next step we configure our source and target connection.
3.) The Table Mapping Dialog allows us to specify which tables should be exported. You could also rename the table or append a timestamp to every table created (useful for regular backups).
4.) If necessary you could also configure a specific field mapping. In our example we would like to fill the field ‘City’ with the static value ‘New York’ and replace the strings ‘Mr’ and ‘Mrs’ with 0 respectively 1.
5.) To start the process just click ‘Start’ and dbCOPY automatically creates the table structure and copies the data. In our example it just takes 765ms to build the structure and transfer more than 900 records.
6.) You can immediately check the results with the integrated database viewer.
We hope that this walk-through explains to you how easy it is to migrate data from Paradox to another database with dbCOPY. In case that you have any questions please do not hesitate to contact us!
We are glad to announce that dbCOPY 4.1 is online and ready to be downloaded. Among many other improvements, we implemented several new features in our database viewer. From now on you are able to open several tabs at the same time and to create filters to limit the amount of data shown. Both features were frequently asked for and we are especially happy to fulfil these requests today. Furthermore, you’ll find many other improvements spread over dbCOPY and a number of bug fixes. This does also include a severe bug concerning SQL Server in specific network situations. For our German customers, we are happy to offer also a localized version of dbCOPY – Just start dbCOPY on a German Windows system to take advantage of this translation.
If you have any other feature requests or questions please do not hesitate to contact us!
Zur Zeit arbeiten wir an der deutschen Version von dbCOPY 4.0.
Diese neue Version wird neben Bugfixes auch mehrere neue Features enthalten. U.a. ist ein Tab-Table Viewer und eine Filterfunktion im Viewer vorgesehen.
dbCOPY Pro provides a console application for executing saved copy profiles.
Therefor go into the dbCOPY program folder and call dbCOPYCC.exe like follows:
dbCOPYCC -file:path|-profile:path [-quiet] [-verbose] [-log:file]
-file:path Executes an exported copy profile.
-file:path Executes an exported copy profile.
-quiet Prints only application failures.
-verbose Prints detailed information.
-log:file Saves the copy log file at the specified location. A standard log file will be created by default.
Executing an exported copy profile:
Executing a saved profile:
We fixed some bugs concerning mySQL 4.1 with our latest update. Thanks Thomas for reporting this bug! Additionally, we updated the mySQL Connector and some internal libraries. Unfortunately, we have to wait for mySQL to fix some other bugs regarding mySQL 4.1.
You can download the latest version of dbCOPY in your personal login area.
We received so much feedback that you would like to have a Paradox database module integrated into dbCOPY 4. Since it was also a big success in dbCOPY 3 we decided to handle it as a top priority and published the Paradox module end of last week. At the moment it supports only read operations but we are on the way to implement writing and updating as well.
Please have a look at our walk-through which explains in-depth how to export data from Paradox to mySQL.