Stored Procedures Only

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 15, 2004 6:53PM in SQL Compare Previous Versions
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.

Comments

  • Hi Brian,

    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?
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Jeff,

    It's all or nothing with Extended Properties, I'm afraid...
This discussion has been closed.