Member Avatar for srdva59

hi,
i have two databases and each one have diferent fields names and tables
and i want a creat a map for each field and each table and export to a database to the other
i have tested the mysql migration but i can´t choose a diferent table in the destination
database.
any one know a software that does this?
thanks a lot for your help
:)

  • 3 Contributors
  • 2 Replies
  • 94 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Member #120589

Dani AI

Generated

— there are three practical ways to map fields/tables between two MySQL databases. and already pointed out GUI tools (useful for simple transfers); for controlled, repeatable mapping consider either explicit SQL, an ETL job, or transforming the SQL dump.

For small numbers of tables and simple 1:1 column mappings, the cleanest approach is explicit SQL. Example pattern:

INSERT INTO dest_db.dest_table(dest_col1, dest_col2)
SELECT src_colA, src_colB
FROM src_db.src_table;

Always list columns explicitly, run inside a transaction (or batch), and use CAST/CONVERT where types differ. Disable foreign key checks during bulk loads, re-create indexes afterward, and preserve auto_increment behavior if needed.

For larger or recurring migrations, use an ETL tool (Pentaho Kettle, Talend Open Studio, or a commercial tool). Workflow: connect both servers, map source fields to destination fields visually, apply row-level transforms (date formats, concatenation, lookups), preview rows, and schedule the job. This is safer when you must merge tables, split columns, or apply many transformations.

If you prefer file-based work or need a one-off, dump the source and rewrite names in the dump (careful with backticks and constraints) or write a small script (Python/PHP) that reads rows from source and writes to the mapped destination using a column-mapping dictionary. In all cases: test on copies, verify row counts and checksums after import, back up the target first, and check character sets and privileges before switching to production.

Recommended Answers

All 2 Replies

Member Avatar for pritaeas

http://www.navicat.com/

I've used this a long time, and am very content with it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.