Delete common objects from one database
On a test server, I copied certain functions, procs, tables and views from a big database to a smaller new app database. Now I'd like to remove most (but not all) of those objects from the big database. I run compare and get a nice list of everything in common. Can I create a script in SQL Compare to delete selected common objects from the larger database that have been recreated in the new app database?