Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in EMS SQL Manager for MySQL?

April 26, 2017changes database EMS master objects perform purpose Test tools

0

Posted

I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in EMS SQL Manager for MySQL?

1 Answer

0

Posted

Database Registration Info dialog contains Log tab where you can enable logging metadata changes, which are performed on a database, and SQL statements, that are executed in SQL Editor. You should switch on the ‘Enable log of metadata changes’ option for your test database, make the necessary modifications in the database and then execute the metadata log file on your master database.