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?
5
-
1It is not possible using generic SSDT schema compare. But you can use SMO (SQL Server Management Objects) to write a powershell script doing it.– Piotr PalkaCommented Jul 1, 2019 at 21:18
-
Thanks, @Piotr, I will research SMO. If you have any resources, it'd be great. Thanks again.– Victor BarajasCommented Jul 1, 2019 at 22:42
-
1Please check this one: powershell.org/2013/04/…– Piotr PalkaCommented 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/…– Rajesh RanjanCommented 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.– Victor BarajasCommented Jul 2, 2019 at 18:20
Add a comment
|