We have two Database environment server (Development and Production). Production DB is already being used in Production(means it already has production data etc.).

My question is, is it possible to migrate databases(structure only) from Development to Production without affecting the data that is already in the Production server?

Note that, there are already changes made in the Development databases, means some of the tables/columns in a table exist in Development but doesn't exist yet in our Production database.

I'm using Workbench Community 6.2 as client.

Our Development database is using MySQL Community and our Production database is using MySQL Enterprise.

  • what type of changes You do on developer server? there are many tools for schema synchronisation, but not all changes could be applied without lost data – a_vlad Nov 27 '15 at 3:39
  • We are altering tables(adding columns)/adding new tables on development server. @a_vlad – wasp8898 Nov 27 '15 at 3:44

If You already use MySQL Workbench, You can use menu: Database -> Synchronise with any Source

Before apply changes it show You script, which You can copy and if need edit You can test it on copy of databases

Also there are many other tools:

  • Navicat
  • SQLyog
  • dbSchema
  • and etc

example of script:

ALTER TABLE `test_db`.`company1_name` 
ADD FULLTEXT INDEX `Company1_name` (`Company1_name` ASC)
| improve this answer | |
  • thanks @a_vlad, we are trying to use the synchronize on the workbench. – wasp8898 Nov 30 '15 at 23:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.