Loading reports into database

rbuser

We've been wondering if there's a way to load reports using a SQL Query
(copying from one database with nothing but the RB tables into another that
may have pre-existing reports already loaded) or using something that can be
executed from DTS (not using a custom application, etc.).

We're using SQL Server 2000, and have had trouble copying from one database
to another when there are already reports in the destination database.

Any suggestions?

TIA.

nardmoseley

Perhaps other customers can chime in here with their experiences.

I think a custom import application is your best bet. Perhaps there is some
automated SQL Server solution that can be used such as DTS, we do not have
any experience with this.

If you load reports into existing database tables used by the ReportExplorer
then you need to specify a FolderID for each report item.

--

Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Maybe I'll spend some time trying to figure out how to do this with SQL
scripts. The heart of a report is an image field, right, which can be copied
using SQL without problems AFAIK.

I'll let you know how that turns out.

nardmoseley

Cool. If you find a good solution, it would make a helpful tech tip for
others.

--

Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com