5
Is there any way to view a View created in Postgres and view in Mysql? If so, how to configure?
2 answers
1
No, one bank can’t access the other. What you can do is, build an application that will serve as a bridge between these two Servers and use a dataset to feed one another with the information from the view in question.
-
In fact yes, one bank can access the other: Linked Server in SQL Server, Database link Oracle
-
@gmsantos The problem is having these features in Mysql and Postgresql.
-
On the Postgre side there are Foreign Data Wrappers, unfortunately I don’t know an equivalent for Mysql.
1
It seems that this is not possible. Mysql has a engine FEDERATED to connect to external banks. Unfortunately, the current version of Mysql (5.7) limits federated access to other Mysql banks (link to the documentation).
Mariadb, one Fork Mysql has a engine CONNECT able to access Postgresql through OBDC, but as far as my knowledge goes engine is not compatible with Mysql.
Source: Soen - Do Databases Besides Postgres have Features comparable to Foreign data Wrappers?
Browser other questions tagged mysql postgresql connection odbc
You are not signed in. Login or sign up in order to post.
Have you seen this ? https://mariadb.com/kb/en/mariadb/documentation/storage-engines/connect/connect-table-types/connect-table-types-odbc-table-type-accessing-tables-from-other-dbms/
– Motta
@Motta this table connect is very similar to the Federated engine in mysql. Too bad mysql only supports itself.
– gmsantos
i know postgresql can access mysql, I’m not sure about the reverse path: http://pgxn.org/dist/mysql_fdw/
– Tobias Mesquita