Creating a Copy of a Database Object

dbForge Studio for MySQL gives you the duplicate object feature. You can make an exact copy of a database object in the same or different database of the same server. It can be very useful for database designers.

To copy an object, right-click its node and select Duplicate Object on the shortcut menu. Then, select a destination database and type a new object name. If the selected object is a table, you can copy data from it or create an empty table copy.

Note that if you copy a table with foreign key constraints, these constraints will not be copied because there may be no referenced tables in the target database.

You can copy objects of following types:

  • Tables
  • Views
  • Stored procedures and functions
  • Packages
  • Sequences