function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SahasraSahasra 

Data Transfer from postgreSql To MySql by using Java

HI All

 

How can i transfer the data from PosTgre SQL to MySQL by using the java. Can u Pls help me

 

 

Thanks &Regards

Sahasra.

 

 

LakshmanLakshman

Not sure about direct utility, but you can always export data in comman format like CSV or generate SQLs from first data source and import in other data source.

HaagenHaagen

Hi,

 

if you are looking for continues integrations between the databases you can look at tools like Rapidi or Jitterbit.

 

Cheers!

 

Martin

WillNWillN

You could also use a tool like Informatica On Demand to connect between the different data sources

RamyaKrishnaRamyaKrishna

HI,

 

Can You please tell me the step by step procedure to create & use the Java Plugin in Jitter bit?

 

 

Thanks,

Ramya

 

Jamie MartinJamie Martin
You can do it via CSV files, but still, it`s a quite long story. If we speak about a more convenient way to do a direct transfer from PostgreSQL to MySql I can recommend you Skyvia (https://skyvia.com/pricing)- cloud-based solution, which is much cheaper than Jitterbit or Informatica.