Creating a Copy of a Database Object

bForge Studio 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 on 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 in 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.