Odoo Help


Connect mysql with postgresql in odoo

on 2/29/16, 12:54 AM 595 views

How to Fetch data from Mysql and put into Postgressql using Server Action.

eg.select data from the mysql tables and copy into postgressql table.

On 2/29/16, 2:59 AM


first you have to install pymssql...(pip install pymssql)

Then create one server action by below python code:

conn = pymssql.connect(server=your_obj.url, port=your_obj.port_no, user=your_obj.user_name,password=your_obj.password, database=your_obj.database_name)

cur = conn.cursor()

cur.execute("SELECT col_name from your_table")

Thank You

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 2/29/16, 12:54 AM
Seen: 595 times
Last updated: 2/29/16, 3:06 AM