1

Topic: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

Prompt please,
At me the information is stored in three bases: MySQL, MSSQL, PostgreeSQL.
It is necessary to tighten the data from the table on MSSQL and the data from the table on PostgreeSQL.
Data needs to be tightened in basis on MySQL, and to save in the table. Then with these given to work.
It is possible from MySQL will be knocked in  PostgreeSQL?, to subtract the table and to save, then will be knocked in MSSQL to read the table and to save in MySQL?
If it is possible, as it to make?
As a variant in  to make connections to 3 bases and in the code to register, will be connected to one basis, to find the data and to save in another;
But can eat a method what from MySQL will be connected to other bases?
In advance I thank for the help.

2

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

MySQL it is not able to be connected to a DBMS of other type. All (or nearly so all) the remaining mentioned names of a software are able.

3

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

Panchenko Dyma wrote:

As a variant in  to make connections to 3 bases and in the code to register, will be connected to one basis, to find the data and to save in another,

Then MS Access.

4

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

Simply wanted to write a script in which the data in the temporary table would gather and in the end to produce result (that the user would launch this script in MySQL and the result would preempt in )

5

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

And what hinders the user to collect the data in the Ex-fur-tree straight from MS SQL and PG? What for in this chain a superfluous link?

6

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

It is necessary to generate the list
And . To the list, it is necessary to fasten conditions leaning against the data from other bases

7

Re: Reading of tables in one basis (MSSQL, PostgreeSQL) in other basis MySQL

It is all without special problems becomes directly in Eksele.