Re: Porting SQLReportWriter Files between operating systems
Date: Thu, 24 Nov 1994 13:44:52 GMT
Message-ID: <1_at_atstoo.win.net>
In article <92486.nstn1389_at_fox.nstn.ca>, nstn1389_at_fox.nstn.ca (nstn1389_at_fox.nstn.ca) writes:
>I am looking for information, documentation and/or SQL scripts that will
>facilitate porting SQLReportWriter (ver 1.1) files between SunOS 4.1 and
>Solaris 2.3. The databases are Oracle 7.0.13 and 7.0.16.
>Any help is appreciated. Tks.
>
> --
> Rowland Spear
> nstn1389_at_fox.nstn.ca
>
Try the 'dumprep' and 'loadrep' facilities included with
SQL*ReportWriter 1.X. The 'dumprep' creates an ascii file with
the extension .rex. It doesn't do any good to try to edit the
file but being ascii it is easily transported.
On the new machine, the 'loadrep' will recreate the report definitions in the new database. It will be helpful and might even be necessary to make sure all the database objects used in the report already exist in the new database.
Hope it helps
Michael Received on Thu Nov 24 1994 - 14:44:52 CET