StrataFrame Forum » StrataFrame Database Deployment Toolkit » Issues » Error DDT Deploy in Create View "Extended properties are not supported"

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

Jose Bressan(1) — Wed, 06 Feb 2013 15:27:25 GMT

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

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

Jose Bressan(1) — Wed, 06 Feb 2013 15:27:25 GMT

Hi Ben,

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

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

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

StrataFrame Team — Wed, 06 Feb 2013 12:33:53 GMT

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.

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

StrataFrame Team — Wed, 06 Feb 2013 12:28:24 GMT

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.

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

Jose Bressan(1) — Wed, 06 Feb 2013 12:25:50 GMT

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

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

StrataFrame Team — Wed, 06 Feb 2013 08:51:20 GMT

Do you have the schema-bound checkbox checked on the view?