Odoo Help

Welcome!

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.

1

Connect mysql with postgresql in odoo

By
vijay
on 2/29/16, 12:54 AM 488 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.

0
Divya-browseinfo
On 2/29/16, 2:59 AM

hello..

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)

Stats

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