pramod.sivadas Posted February 7, 2011 Share Posted February 7, 2011 I am now working on a project, which is upgradation of a Job board. The new site is having slightly different database schema. The customer want to import the data from old database to the new one. I am planning to write a custom php script for data import. Before that I would like to know whether there is any free tools available for this data migration. The database I am using is Mysql. Any help will be appreciated. Thanks Pramod Quote Link to comment https://forums.phpfreaks.com/topic/226947-migrate-data-from-one-database-to-another/ Share on other sites More sharing options...
Hybride Posted February 7, 2011 Share Posted February 7, 2011 What is the first database? You can probably just use the database itself to export as SQL statements, and then import into MySQL. Quote Link to comment https://forums.phpfreaks.com/topic/226947-migrate-data-from-one-database-to-another/#findComment-1171181 Share on other sites More sharing options...
lastkarrde Posted February 7, 2011 Share Posted February 7, 2011 MySQL has it's own dump utility (used from the command line). Most (My)SQL GUI clients (phpmyadmin, HeidiSQL, NavCat etc..) also have an easy dump/restore option available. Quote Link to comment https://forums.phpfreaks.com/topic/226947-migrate-data-from-one-database-to-another/#findComment-1171201 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.