migrating from paradox to advantage

rbuser

RBuilder Pro 7.04
Delphi 7

Hi...
We are considering to change our app database from BDE to Advantage.
We have more than 400 .RTM files for our customers, and they surely have
more created by them.

When we try to open/load a .rtm file (bde-paradox) with the new
advantage application, it raises the following exception:

"Class TdaBDEQueryDataView not found"

I think .rtm files contain the database type, session, tables used, etc...
Can we override those parameters when loading old reports?
Can we change/fix this? Is it possible?

If not, I'm afraid we will desestimate the migration.

nicocizik

Hi Santy,

There is no utility to convert your templates, but it should be rather easy
to create one (we have had many customers do in successfully). Here are the
steps we recommend.

1. Select one report from your existing database and save it to file (in
ASCII format).
2. Recreate this report from scratch connecting the new report to the new
database using Advantage and save it to file (in ASCII) as well.
3. Compare the two report templates in a text editor and determine which
items need to be changed in the first template.
4. Try manually changing the first template and see if you can get it
working with the new database.
5. Take a look at the following example of editing a template as text while
it is still on your database. Using this logic, you could open a template
from your existing database, alter the template code as you need, then save
the templates down to your new database all in one step.

http://www.digital-metaphors.com/tips/EditTemplatesAsText.zip

Hope this helps.


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com