Fix for DbEngine when deploying SPROCS for non-dbo schemas

Trent L. Taylor — Mon, 24 Mar 2008 15:51:03 GMT

In the 1.6.5 build, we changed the DDT to use extended properties on the database, stored procedures, views,and UDFs so that in environments where there may be a DBA they can add their own without being removed the next time the meta-data was deployed. In doing so, we accidentally introduced a bug related to those extended properties. So now, when a schema other than DBO was being used, the DDT did not "see" the extended properties and thus did not remove them prior to attempting to re-deploy them which resulted in an error. This issue has been resolved with this assembly. Extract the attached ZIP and do the following:

Close the DDT and Visual Studio
Copy the DLL and XML both to the c:\program files\common files\microfour\strataframe folder
Drag the DLL into the GAC (c:\windows\assembly)
Go back into Visual Studio and/or the DDT and redeploy your package. The error should be resolved.

RE: Fix for DbEngine when deploying SPROCS for non-dbo schemas

Trent L. Taylor — Mon, 24 Mar 2008 15:51:03 GMT

After testing, another minor bug was found when deploying using the previous fix to a database that did not have the extended property set. This attachment fixes the error.

StrataFrame Forum » Updates and Information » Posted Releases » Fix for DbEngine when deploying SPROCS for non-dbo schemas

Fix for DbEngine when deploying SPROCS for non-dbo schemas

RE: Fix for DbEngine when deploying SPROCS for non-dbo schemas