Removal of programmable object

ebb

Hi,

I’m evaluating whether SQL Change Automation, is a good fit for our Data Warehouse development cycle.

Looking at the documentation for Programmable Objects, and also testing in Visual Studio – I can’t figure out how to handle the removal of ex. a stored procedure?

Let’s say I have some stored procedure that I want to remove from the database – I therefore delete the programmable object in my SQL Change Automation project.. But this won’t delete the stored procedure in the database, but just the SQL Change Automation project.

Therefore my question is:

How do I delete a programmable object in the SQL Change Automation project, so that it is also reflected in the actual target database?

MikielAgutu

Hello

If SQL Change Automation doesn't recognize the deletion of a PO then you'll have to manually delete the object from your development DB.

1. In the target database, drop the PO (e.g. using SSMS or the SQL Server Object Explorer in Visual Studio)
2. In the SCA tool-window, import the change from the target database by clicking Import and Generate Script (This will generate a migration to drop the PO, and also remove the contents of the PO script from the project)
3. Optionally, delete the empty PO file from the project

Thanks