Fix for DbEngine when deploying SPROCS for non-dbo schemas
 
Home My Account Forum Try It! Buy It!
About Contact Us Site Map
StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      


Fix for DbEngine when deploying SPROCS for...Expand / Collapse
Author
Message
Posted 03/21/2008 1:10:28 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926
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:
  1. Close the DDT and Visual Studio
  2. Copy the DLL and XML both to the c:\program files\common files\microfour\strataframe folder
  3. Drag the DLL into the GAC (c:\windows\assembly)
  4. Go back into Visual Studio and/or the DDT and redeploy your package.  The error should be resolved.
Post #15092
Posted 03/24/2008 3:51:03 PM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 3:24:00 PM
Posts: 3,733, Visits: 3,926
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.

  Post Attachments 
StrataFrameDbEngine.zip (15 views, 92.76 KB)
Post #15142
« Prev Topic | Next Topic »

Reading This TopicExpand / Collapse
Active Users: 1 (1 guest, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 2:32am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 10 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.