Odoo Help


This community 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.


Connect mysql with postgresql in odoo

on 2/29/16, 12:54 AM 446 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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


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