SQL 2 XML

This project involved providing administrative users an interface to define parameters such as date range and specific databases to produce an export of a precise XML schema. I created an archives database which captures the database, table name, PK, User and date of each export. When the export is run again, the SP checks against the archives db to see if the data has been previously exported. If it has, it checks to see if the data has been updated since the last export - and of it has adds an 'updated' attribute so that the export flags data which has been previously exported.

• Created Stored Procedure using SQL Server 2000's For XML Explicit to define schema
• Developed simple ASP form for users to select parameters of export
• Created documentation for training and maintenance