DDT, SProcs and Views . . . Oh, My!


Author
Message
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
For a new project I imported 2 tables into the DDT.  No stored procedures were imported.  No views were imported. 

I made sure that object name history was clear.

I edited these two tables.  I also added two new tables to the DDT.

The object name history was looking good and ready for a deployment.

I deployed my changes to the database.  At this point, I have four tables that should be showing up in the table list with my changes.  They did!!  Suh-weeet!  This is great stuff...and so easy. w00t

Maybe too easy!?! 

At the time I did not know it, but ALL stored procedures were dropped from the database.  ALL views were dropped from the database.  Only table schema should have been altered in the DB, right?  Did I blow by some checkbox somewhere that says, "Drop all SPs/Views"?  What configuration of the DDT would cause this behavior? 

Please help me so that I am not dropping things every time I deploy changes to my database.  Hehe

Thanks,
Bill

Replies
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
It will require a full version of SSMS.  But once you have it, just right-click a sproc that the DDT depoyed, go the extended property and delete it.  If you want to do it in code...well, that is more complicated BigGrin
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
Group: Forum Members
Posts: 785, Visits: 3.6K
Simple enough.  Thanks!!
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search