Create Active Directory schema into OpenLDAP
Hi Friends, I need to store Active Directory Data into OpenLDAP and for that I want to create the Active Directory schema into OpenLDAP. How to do it? ...
schema
Application that modifies its underlying db schema
Under what circumstances (if any) would you allow an application to change its underlying database schema? I.e. to add new column. EDIT: A little bit of elaboration on what prompted me to ash this question. My system receives raport files from other systems and saves fetched data in "reports" table. Report includes several "parameters" ...
In sql server, is there any way to check whether the schema change will impact on the stored procs?
In SQL Server, is there any way to check whether the changes in the schema will impact Stored Procedures (and/or Views)? For example a change of the column name in one table, may break some Stored Procedures; how to check the impacted stored procs? ...
Flattening XSD schema documents (HR-XML 3.0)
I have several "main" XSD documents, which import "supporting" XSD documents. These schema documents happen to be from the HR-XML 3.0 specification, in particular related to Background Screening. For the purposes of code-generation and convenient single-file schema to reference in my WSDL, I am trying to "flatten" the schema. The import...
Enumeration of a complex type
How can I make an enumeration of a complex type? For example, I want to store the following data into a xsd enumeration called Measurings description tag item item tag fileName each one of these attributes has an specific value and this set makes one registry in my ennumeration. But the problem is that as far as I know, it's allo...
Sub-Schemas in SQL Server 2005/2008
This is a simple question yet I was unable to find any information at all about this. Is it possible to have sub-schemas in SQL Server 2005/2008? Example: Having a HR (Human Resources) schema with a sub-schema called Training (with tables related to this). It would end up like HR.Training.* where * would be the tables. ...
Print DataBase Schema in Sql Server Compact Edition
Hi All I Want Print DataBase Schema in "Microsoft Sql Server Compact Edition". Maybe Exist Some Tools For it. How Can I do it? ...
Schema Inheritance in BizTalk Server
Hi, I just wondering if anyone has already tried of doing something like schema inheritance in BizTalk schemas? I am using WCF Adapter and using 'consume adapter service' to generate a schema automatically, what I wanted is instead of always generating a schema and since most of my schema is the same then I want to have something like ...
Design ideas for a versioned db schema with related tables also versioned
Here is the drill, I want to version a database. I have done this before using multiple rows where the table primary key becomes a combination of the row id and either a datestamp or a version #. Now I want to version a table that depends on many other small tables. Versioning each table will be a giant PITA, so I am looking for goo...
Rails with DB2 and multiple schemas
I have a 'legacy' DB2 database that has many other applications and users. Trying to experiment with a rails app. Got everything working great with the ibm_db driver. Problem is that I have some tables like schema1.products, schema1.sales and other tables like schema2.employees and schema2.payroll. In the ibm_db adapter connectio...
Describe repeating XML nodes in W3C XML Schema?
I have an XML document like: <Root> <Bravo /> <Alpha /> <Charlie /> <Charlie /> <Delta /> <Foxtrot /> <Charlie /> </Root> The order of the nodes does not matter. Each node may appear zero or one times, except for Charlie. Charlie may appear zero, one, or arbitrarily many times. The straightforward way to ex...
Documenting and defining content types for a CMS or similar project
I'm writing up some documentation on a Drupal project and my task is to define the content types and their attributes. The intended audience is project managers and developers. So it could be a high level document that gives an overview of the system. (I think that's how I describe it: high level rather than high detail) At the moment I...
xs:choice unbounded list
I want to define an XSD schema for an XML document, example below: <?xml version="1.0" encoding="utf-8"?> <view xmlns="http://localhost/model_data" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://localhost/model_data XMLSchemaView.xsd" path="wibble" id="wibble"> <text name="PageTitle">Homepage</text>...
Creating a 'flexible' XML schema
I need to create a schema for an XML file that is pretty flexible. It has to meet the following requirements: Validate some elements that we require to be present, and know the exact structure of Validate some elements that are optional, and we know the exact structure of Allow any other elements Allow them in any order Quick example...
Schema generated from WCF web service and ASMX are different
I have the following class [Serializable()] [XmlType(AnonymousType=true)][XmlRoot(Namespace="", IsNullable=false)] public class Test { [XmlAttribute()] public string Prop { get; set; } public string Another { get; set; } } I used this class in both a WCF web service (SVC) and an ASMX web service and I'm expectin...
Generate annotation along with schema from class
Hi, Do you know if we can add comments in the class and when we generate schema from it using xsd.ece, it should place annotations in the schema> ...
PHP - Database schema: version control, branching, migrations.
I'm trying to come up with (or find) a reusable system for database schema versioning in php projects. There are a number of Rails-style migration projects available for php. http://code.google.com/p/mysql-php-migrations/ is a good example. It uses timestamps for migration files, which helps with conflicts between branches. General pro...
Is there a way to export an XSD schema from a DataContract
I'm using DataContractSerializer to serialize/deserialize my classes to/from XML. Everything works fine, but at some point I'd like to establish a standard schema for the format of these XML files independent of the actual code. That way if something breaks in the serialization process I can always go back and check what the standard sch...
How to create a user customizable database (like Zoho creator) in Rails?
I'm learning Rails, and the target of my experiments is to realize something similar to Zoho Creator, Flexlist or Mytaskhelper, i.e. an app where the user can create his own database schema and views. What's the best strategy to pursue this? I saw something about the Entity-Attribute-Value but I'm not sure whether it's the best strategy...
Validate JSON against a schema in .Net
I know there is a proposed standard for JSON schema validation, is there an implementation in .Net? ...