Off late, I am searching the internet for a custom solution to automate SQL server database changes deployment. Can I use SSDT to just maintain changes to the database rather than creating a database project and import the entire database.?
I have 3 or 4 third party applications which have their own SQL databases. I am tasked with building an integration between these applications(essentially between these databases in real).
All I need is to write few stored procedures, functions, triggers and create few new tables to the existing database(s). Can I use SSDT for my task without importing the entire database into the database project but only starting with the changes? Any pointers on this are much appreciated!
TIA.