Hi!
Here is the problem!
By a web service, I export table's data in XML file and XML Schema. After, I download this files localy (on PC or PPC) and I need to have all my relation and data structure. So, I need to take this XML files and create .mdb or .cdb with all data relation, field type and length, not null, pk and fk. I need to to that 'cuz I'll query this database with another program.
- I export my query and schema in .xml
- Download this file localy
- QUESTION: How I can create my .mdb/.cdb with my .xml files I need to have all relations/data type/attributes(not null / length / pk / fk)
Another way: It is possible to export the CREATE TABLE structure of a Oracle table with all parameters After I'll create this database localy on a mdb/cdb and I'll do a simple insert of my xml files.
-DATABASE: Oracle9i R2
-PC with framework 2
-PPC with CF2
-Other program's like Esri ArcPad7
thx very much.
xml database
jherbst
What you'll need to do is create a schema document for your XML that describes the structure. XML is just text, so laying it out with attributes takes either a schema, or you could define the attributes as part of the XML and write some code to shred it into a database. There's nothing else that does that automatically.
I've written a series of articles that might help you understand XML in SQL Server 2000: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=123
Buck
Carpe Datum
ra7207
Rikidude,
Have a look at: http://www.informit.com/articles/article.asp p=29901&seqNum=1
Sinan
sharon n.