ReportServer Forum

cedispin

Member

Registered: 2014-12-12

Create RS DB with Firebird

Hi

I would like to use the Firebird as database to ReportServer, it is possible?

I didn't found the rs schema in ddl folder to Firebird.

Tks

Carlos

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: Create RS DB with Firebird

Hi Carlos,

have a look at http://blog.datenwerke.net/2013/06/addi … bases.html.

More information is also available in the script and admin guides.

Cheers
Arno

cedispin

Member

Registered: 2014-12-12

Re: Create RS DB with Firebird

Arno

Thank you for your help!

But Do I need to setup the persistence.xml to use firebird as my default reportserver database?

Tks

Carlos

Thorsten J. Krause

datenwerke

Registered: 2012-02-15

Website

Re: Create RS DB with Firebird

Carlos,

firebird is officially only supported as a datasource, not as storage for the reportserver database. That doesn't mean it won't work, but it requires some extra work:

in the persistence.xml use these settings:
dialect: org.hibernate.dialect.FirebirdDialect
driver class: org.firebirdsql.jdbc.FBDriver
jdbc url: jdbc:firebirdsql://host[:port]/<database>

to create the tables you have to adapt one of the ddl scripts provided with reportserver so it works with firebird.

Cheers,
Thorsten

cedispin

Member

Registered: 2014-12-12

Re: Create RS DB with Firebird

Thorsten

Than you for your information!

I am going to test it.

Tks

Carlos

Thorsten J. Krause

datenwerke

Registered: 2012-02-15

Website

Re: Create RS DB with Firebird

Carlos,

I didn't test them, but instead of writing you on ddl based on one of the existing script, you can also try these:

http://www2.datenwerke.net/files/forum/ … CREATE.sql
http://www2.datenwerke.net/files/forum/ … d_DROP.sql

Thorsten

cedispin

Member

Registered: 2014-12-12

Re: Create RS DB with Firebird

Thorsten

Thank you for these scripts.

I runned it but it didn´t work very well. I changed the script but it not work yet.

I am still working in this issue.

Tks

Cadu