export report to another database

rbuser

Hi,

I've this problem:
I want to transfer report between 2 database, what can i do? if i understend
well, report on sqlserver are saved into binary data (stream?), can i create
a program or sql script that transfer the report?
Otherwise can i create automatic function that read rtm file (saved before)
and load directly onto database? or replace a report directly?

thanks

nicocizik

Hello,

Are you trying to transfer the report template between two SQL Server
databases or two completely different types fo databases? If you are
transferring between two SQL Server databases, it should just be a matter of
loading the template blob field to a TBlobStream, then saving that data to a
blob field in another database. You should be able to do all of this in
Delphi without the help of ReportBuilder.


--

rbuser

I want to transfer to 2 sqlserver (with same structure) databases.
The problem is that I don't have both server connected...

... it's like make a software update (i want to run a script to update the
report)... it's not this , but similar....

rbuser

> I want to transfer to 2 sqlserver (with same structure) databases.

Save it to a file. Then read the file.

nicocizik

Hi,

Frederic is correct, you will need to save the binary data to a file, open a
connection to your other database and load the file into a blob field in
that database.


--