Good afternoon, my problem is the following:
I have a SQL Server database to which I made a backup to work from another PC and make some updates by modifying some stored procedures and integrating new procedures.
Users interact with the database through a vb.net application, they enter information, edit, delete etc.
For example: My database at the time of making the backup had 3 tables and 3 Stores Procedures.
Now after working on it I have 4 tables and 10 store procedures.
Now I want to integrate the new updates that I made to the old Database.
How can I do it without doing a full database restore? I only want to integrate the new since the old database could have new data inserted by users connecting to it through the app.
I hope I explained myself in the right way, I appreciate the help.
Based on the comments:
In this last part this script is only to give theF5
UPDATE:
To include them
IF EXISTS
you have to modify an option in the script configuration window:And now it would be ready: