Re: Schema Includes Another Schema

Also...I'm almost certain that you don't mean xsd:include, but SQL Server
2005 doesn't support xsd:include. You need to combine all of the files for
one XML namespace into one XML schema varaiable.

Cheers,
Bob

"Neal Walters" <NealWalters@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:56B69EC6-4E66-4D05-B174-445B2BFC8B70@xxxxxxxxxxxxxxxx
I would like to build a schema with Biztalk, then use to define as an XML
column.

The trick is that I want to use nested schemas. For example, I want to
create a schema called TradingPartnerCommon.xsd, then include that in two
other schemas: 1) TradingPartnerProvider.xsd and 2)
TradingPartnerSubmitter.xsd. This will allow me to enforce some
commonality
between different types of TradingPartners.

I know in the past from using Stylus Studio, that other products outside
of
Biztalk have problems finding the source for the second schema.

I'm guessing this isn't allowed. Any ideas though?

Thanks,
Neal Walters
http://Biztalk-Training.com





.

Relevant Pages

  • Re: how to get functions from stored procedures
    ... schemas and a bitmask of the supported restrictions for each schema. ... In the SQL Server case you may ... Providers are not required to support ... >> You don't say which OLEDB provider you are using here, ...
    (microsoft.public.data.oledb)
  • Re: Protecting database structure
    ... can use the new encryption support that comes out of the box in SQL server ... SQL server will only see encrypted data. ... you could do what SAP and other ERP vendors do: obfuscate the schema ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.security)
  • Re: Is it impossible to have schema1.dave and schema2.dave as tables in the same DB?
    ... identifiers of SQL Server Objects. ... different schema names) is supported in both SQL Server 2008 and SQL Server ... Microsoft Online Community Support ... initial response from the community or a Microsoft Support Engineer within ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: sql 2005 schema as the default schema.
    ... alter user foo with default_schema=bar ... Jasper Smith (SQL Server MVP) ... I support PASS - the definitive, ... > instead of me having to prefix tablename with schema name in the query. ...
    (microsoft.public.sqlserver.clients)
  • Re: multiple cascade paths
    ... You should not have them if your schema is designed properly. ... make you understand that I tried to show that a proper design can have ... am a SQL Server MVP, for crying out loud - you can safely assume that I ...
    (comp.databases.ms-sqlserver)
Loading