Click here to Skip to main content
16,017,488 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
If it found i want it to fit:
Xml management tool
Requirements:
1- Make Schema ,editor
2- Can Import from sql database
3- Convert from sql table to xml file
4- File may be consists of multi tables and like(DTD)
5- Tool that contain everything I can do in xml, preferable have license not limited.
Posted
Updated 8-Nov-12 1:51am
v3
Comments
bbirajdar 8-Nov-12 12:46pm    
The shortest answer is - No
bbirajdar 8-Nov-12 12:47pm    
BTW, thanks for the idea. I will write such a tool and it will not be free...
engmebeed 11-Nov-12 7:38am    
Ok this is good, for the idea may i have part of income.hahahah

1 solution

engmebeed446,

There is probably not a single tool that will do exactly what you want, but there are some things that exist that will help.

Try Googling for "sql server for xml"

SQL
USE AdventureWorks2012
GO
SELECT Cust.CustomerID,
       OrderHeader.CustomerID,
       OrderHeader.SalesOrderID,
       OrderHeader.Status
FROM Sales.Customer Cust
INNER JOIN Sales.SalesOrderHeader OrderHeader
ON Cust.CustomerID = OrderHeader.CustomerID
FOR XML AUTO




The "FOR XML" value in SQL Server will output a query in XML. There is a lot of functionality in this space if you look into it.

Good luck!

Hogan
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900