Home Forums SQL Server 2008 SQL Server Newbies Copy certain tables,stored procedures and views from one Database to another RE: Copy certain tables,stored procedures and views from one Database to another

  • It would be much more simple to script the objects in SSMS and execute the script against the database that you want. Any and all databases that you want. When generating the script, you have the options to pick only the database objects that you need or want. This will script the constraints and indices in order of creation.

    Andrew SQLDBA