How to link two or more databases on different servers?

V

V_i_t_a_l_i_y_Brooks2021-05-17 17:50:28

PostgreSQL

V_i_t_a_l_i_y_Brooks, 2021-05-17 17:50:28

There was a task to connect some databases, in one.
The databases are located on different servers, please tell me where to dig?

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

K

ky0, 2021-05-17
@ky0

If I understand you correctly - you need Foreign data wrappers .

V

Vitaly Kachan, 2021-05-17
@MANAB

Well here it is not clear, what problems in these 2 DB here. Do they contain different tables and data? Take the structure of one database through SQL Server Management Studio, add it to the second, then transfer the data through Import / Export.
If these are 2 identical databases but with different data, then only through the definition of the principle how to merge this data. But anyway through Import/Export and some temporary tables.