I am evaluating AETLP trial version 3.7.0.6.
I have a MS SQL Server CE database file from another program, and I would like to use AETLP to keep it in sync with a MySQL database. The sync only needs to go one way (CE -> MySQL).
I am beginning with an empty MySQL database, and would like to start by populating it with the tables/fields. I can see that it is possible to import the data one table at a time into an existing table, but there are numerous tables with many fields, and manually creating all of them in MySQL would be very tedious.
When I enter the Data Reader Properties dialog, I see that it is possible to select multiple tables. But when I enter the Writer dialog, it asks for a target table or procedure.
I would like to know if there is a way to make the target table a wildcard, or tell the program to replicate the tables that do not yet exist.
After that, I would like to be able to run a configuration to read the entire CE database and update/add to the MySQL database to keep them in sync. I am just hoping there is a simpler way than to go through configuration for every single table individually. This is obviously a powerful and complex tool, and I am sure I am overlooking something in the dialogs and manual.
I should add that I downloaded Data Exchange Wizard first, and encountered the same question. Upon searching, I found a forum post that suggested that AETLP was more powerful than DEW. However, after installing AETLP, it appears that what I am trying to do could be done with either program. Any input that can get this going for either program would be appreciated.
Thanks for your help.
