How to guide data with DBMS and different DBMS

How to guide data with DBMS and different DBMS
Built a table, in the inside wrote some articles, after a period of time found that the table structure is not good, want to change, column ID use CATID, with the MySQL database,
A table was re-built to specify CATID from the previous database to the target database specifying CATID data.
What if it's a different database? Asp->mysql
------Solution--------------------
Some database management tools have methods for importing. No, you can only find a way to use the two database in a common format to guide, or write programs to guide.

