StrataFrame Forum

Error DDT Deploy in Create View "Extended properties are not supported"

http://forum.strataframe.net/Topic31782.aspx

By Jose Bressan(1) - 2/5/2013

Extended properties are not supported

->    en Microsoft.SqlServer.Management.Smo.View.Create()        
->    en MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.CreateSmoObject(ICreatable ObjectToCreate, String ObjectName, DBEObjectType ObjectType, Boolean verboseLogging)        
-> 
-> An error occurred while deploying the meta-data to the server.
-> SqlException        
->   Objeto no válido. 'config.vc_Ciudad' no admite propiedades extendidas o el objeto no existe.        
->         
-> Source     : .Net SqlClient Data Provider

The error only occurs when I change the view schema of "dbo" to another scheme in this case "config"

Please help me
By StrataFrame Team - 2/6/2013

Do you have the schema-bound checkbox checked on the view?
By Jose Bressan(1) - 2/6/2013

Hi Ben,

Yes, I have the schema-bound checkbox checked on the view

I tried uncheckbox and work fine, but i need  "schema-bound" checkbox checked on

Working
1- Deploy with  uncheckbox "schema-bound"
2- Deploy again with "schema-bound" checkbox checked on


Thank Ben
By StrataFrame Team - 2/6/2013

OK, looks like there is a setting we're not putting on the schema when we first create it, but we are if the schema is already existing.  I'll take a look and see what I can find.
By StrataFrame Team - 2/6/2013

Jose,

Do you have tables in the schema as well, or just views?  I see the logic where we are explicitly creating the schemas for SQL 2005+, but it only gets called for tables, not for views.
By Jose Bressan(1) - 2/6/2013

Hi Ben,


Yes, I have tables in Scheme, and the views in the schema.

Working with MSSQL 2008r2. Image shows the tables and views

http://forum.strataframe.net/Uploads/Images/0600e914-8e51-4b89-9b12-8b7f.png