I have table with many data and also I have new structure in other database and system. Is there any program to convert database to new structure?
This program must read structure of both of them and then ask me which fi开发者_JAVA百科eld fill which field in new table and also which field drop and etc ...
can any body suggest any application do these things for me?
Also my sql file is MySQL and my structure (new table) is PostgreSQL
There are several mysql => postgres scripts listed in the postgres wiki, and there's a good guide on syntax changes here
精彩评论