How to transfer data from one database to another (base structure is different)?

S

Shops2016-12-20 12:39:13

Database

Shops, 2016-12-20 12:39:13

Good afternoon, tell me please, is there any software for setting up the transfer of data from one database to another with a different data storage structure?

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

V

VVB, 2016-12-20
@SEOBot

I think there is no universal solution, because you will not be able to give an answer.
Give more information.

O

Omich, 2016-12-20
@omichkun

Looking what DB.
For MSSQL, it seems like you can do something similar using SQL Server Integration Services.
As for others, it's unlikely.

A

Adgh, 2016-12-20
@Adgh

Yes, look towards ETL solutions:
https://ru.wikipedia.org/wiki/ETL

A

Anton, 2016-12-20
@MoonMaster

It all depends on the database. But modern databases allow you to support the migration mechanism.