Creating a Copy of a Database Object

dbForge Fusion for SQL Server provides the Duplicate Object feature. You can make the exact copy of a database object in the same or another database of the same server instance.

To copy an object:

  1. After connecting to a required instance of the Microsoft SQL Server Database Engine, in Database Explorer, click the server name to expand the server tree.

  2. Click the arrow next to the database icon to expand it.

  3. Expand a required database object folder.

  4. Right-click a required object and then click Duplicate Object on the shortcut menu. The Duplicate Object dialog box opens.

  5. Optionally, in the Duplicate Object dialog box, change a destination database, destination schema, and object name.

  6. Optionally, click Edit script to view or edit the automatically generated T-SQL script.

  7. Click OK.