Changing Database Engine

rbuser

Greetings All,

I am involved in moving a large application from Interbase to MS/SQL Server.

I have sucessfully ported all the data to SQL Server but I am unable to make
the report Explorer switch away from Interbase.

I have exported the reports as a file (normally stored in DB) and replaced
the IBXDataView references to daADODataView, but the explorer still looks
for interbase.

What is the correct way to do this ?

Any help you guys can give me will be much appreciated, there are MANY
reports to convert.


Regards
David.

nicocizik

Hi David,

Each template you have located in your database contains references to a
DADE plugin for Interbase. In order to use these templates with SQL Server,
you will need to manually edit these templates to reference the ADO plugin.

Unfortunately there is no utility available to automatically convert your
templates to use a different database, but it should be rather easy to
create one (we have had many customers do it 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 ADO 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

--
Regards,

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