Changing Database Servers

rbuser

We have a client base using Interbase and now have a rquirement to run the
same reports on MS-SQL .. The databases have been converted but the Reports
fail to load because they now contain references to IBX instyead of ADO ,

Do you have a utility that can change the database so that the files cab at
least get loaded into teh explorer for manual adjustment or some clever
trick ..

I have thought of changing the trext file replacing IBX for ADO strings but
im sure thats toooo simplistic .. Ideas please

Thankyou

nicocizik

Hi Adrian,


Acutally, you're not too far off, it's almost that easy . 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 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

Hope this helps.

--
Regards,

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