CODEWITHSUNDEEP
.netmysqlinformix
sergiogx
sergiogx

Reputation: 1582

Sync tables between different database providers

I have 2 tables in 2 different databases, one is in a mysql server and one is in an informix server.

Using .net and odbc, is there a way to identify the differences of both tables and merge them? so that both informix database and mysql database have the same data.

thanks.

Upvotes: 2

Views: 468

Answers (1)

Cesar
Cesar

Reputation: 4427

AFAIK there are no integration between those 2 database. If it's just one shoot it's better export one of the tables and import into the other db and check.

The other way it's a row-by-row script using the primary keys.

Upvotes: 1

Related Questions