Is it possible for me to have a database project to maintain "only" a selective list of DB-objects or scripts rather than importing the entire/whole database?
I am tasked with writing an integration between some 3 - 4 third party applications. These applications have their own SQL databases. All I have to do is to add few new tables, write few new stored procedures, triggers, and UDFs.
Here are the things I am looking for:
An automated solution for change control, maintenance, and deployment of this subset of DB objects. (I am already using TFS so source control is not an issue.)
Can this be done using SSDT?
If not, are there other options open source?