Stored Procedures Only
Brian Donahue
Posts: 6,590 Bronze 1
Hi Jeff,
The SQL Compare software has to register all of the objects, but you can choose which ones to synchronize. You can limit this to only stored procedures if you click the 'select none' button, change the filter settings to show only stored procedures, then click 'select all' and synchronize.
The SQL Compare software has to register all of the objects, but you can choose which ones to synchronize. You can limit this to only stored procedures if you click the 'select none' button, change the filter settings to show only stored procedures, then click 'select all' and synchronize.
This discussion has been closed.
Comments
Thanks for the information.
When it generates the script of stored procedures, it nicely includes extended properties on the stored procedures. This I need.
It also does extended properties not associated with stored procedures, but with the database itself. Is there a way to get these database extended properties not to be included in the script?
It's all or nothing with Extended Properties, I'm afraid...