Home>

Can the database created with MySql, including the table structure, be scripted?

SqlServer can be easily scripted from SSMS, so database replication without data replication was easy.
I would like to know if MySql also has these features.

  • Answer # 1

      

    SqlServer can be easily scripted from SSMS, so database replication without data replication was easy.
      I would like to know if MySql also has these features.

    How about mysqldump?
    It is also possible to export only DDL
    Mysqldump Summary

  • Answer # 2

    I think that MySQL is Workbench, but there are other DB tools such as A5: SQL and ERMaster.
    Create a table on MySQL server using MySQL Workbench and MWB file
    If you reverse the ER diagram, you can add comments.