Create a copy of a database object
dbForge 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:
-
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.
- Click on the arrow, next to the database icon, to expand it.
- Expand a required database object folder.
- Right click a required object and then click Duplicate Object in the shortcut menu. The Duplicate Object dialog box opens.
- Optionally, in the Duplicate Object dialog box, change a destination database, destination schema, and object name.
- Optionally, click Edit script, to view or edit the automatically generated T-SQL script.
- Click OK.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?