sync data between MySQL and Postgresql

Say,
We wish to use JasperReportsServer 5, which seems to support postgresql as default.
Our data is in MySql 5 on Linux server.
Is there a simple way to sync the data between the 2?
shaunwinginAsked:
Who is Participating?
 
johanntagleConnect With a Mentor Commented:
Follow the instructions in the documentation I mentioned above and you will realize you can add a mysql data source (and more) without removing the default postgresql data source.
0
 
johanntagleCommented:
I think you should just configure Jasper to use mysql datasource.  That will be a way lot easier.  Go to section 4.1 of http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide-v500
0
 
shaunwinginAuthor Commented:
Ok. How can I get the sample data from postgresql to MySql
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
johanntagleCommented:
I don't believe you need to.  Jasper supports multiple data sources so you just add a mysql data source.  You will need to download the mysql jdbc driver from http://dev.mysql.com/downloads/connector/j/ and extract the jar file to the apache-tomcat/lib directory, restart tomcat (I just used the ctlscript.sh script to restart everything.)

In the data source definition you set Driver to com.mysql.jdbc.Driver and URL to something like jdbc:mysql://localhost:3306/test

That's as far as I've gone so far =)
0
 
shaunwinginAuthor Commented:
Tx. Its the sample data that was an issue for us...
0
 
johanntagleCommented:
Again you can keep the postgresql data source with the sample data, then just add a mysql data source for your real data.  No need to transfer data from postgresql to mysql or vice-versa
0
 
shaunwinginAuthor Commented:
I've also my own data that wish to transfer - how can I import data to Postgre?
0
 
johanntagleCommented:
Think you should file that as a separate question and provide details what exactly you want to do i.e. what is the format of the data, etc
0
 
shaunwinginAuthor Commented:
Can one have links to 2x data sources in JasperReportsServer? Please elaborate
Again you can keep the postgresql data source with the sample data, then just add a mysql data source for your real data.  No need to transfer data from postgresql to mysql or vice-versa
0
All Courses

From novice to tech pro — start learning today.