Copy Data Between 2 Tables
Posted 22 February 2012 - 08:22 AM
What is the easiest way to transfer data from one table to another ?
Posted 22 February 2012 - 09:21 AM
Posted 22 February 2012 - 10:39 AM
We plan an interactive/visual 'mode' of Data Synchronization. Something like a 'diff editor' if you know such. It will likely take around 3 months to release. If the databases are on different servers I do not see any option (except for manually comparing and inserting) with SQLyog now. If databases are on same server a single SQL statement like:
INSERT [IGNORE] INTO .one_db.one_table .. SELECT .. FROM other_db.other_table ... [WHERE] ..
.. would do the job (details of how to frame the statement will depend on whether schemas are excatly the same). Refer MySQL documentation: http://dev.mysql.com...ert-select.html
2) transfer all rows
This is what we have Data Synchronization (in its current form) for.
Note: Data Synchronization is an ENTERPRISE/ULTIMATE feature.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users