Is it possible to use schema compare in SSDT to compare only specific objects? Not object types, specific objects like 3 tables and 2 stored procedures instead of all tables and all stored procedures?

  • 1
    It is not possible using generic SSDT schema compare. But you can use SMO (SQL Server Management Objects) to write a powershell script doing it. Commented Jul 1, 2019 at 21:18
  • Thanks, @Piotr, I will research SMO. If you have any resources, it'd be great. Thanks again. Commented Jul 1, 2019 at 22:42
  • 1
    Please check this one: powershell.org/2013/04/… Commented Jul 1, 2019 at 22:48
  • Here Microsoft documented steps to compare schema using SSDT. Hope it'll help you out. learn.microsoft.com/en-us/sql/ssdt/… Commented Jul 2, 2019 at 15:10
  • Thanks @RajeshRanjan. I know how to do schema compares using SSDT, my question was if it's possible to filter objects for the comparison to avoid running the comparison on all the database and instead run it only on a few selected objects. I know you can filter by object types but I want to filter by specific object. Thanks anyway. Commented Jul 2, 2019 at 18:20


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.