Re: XML to Database Inserts via XSLT
Hello Barry,Sybase has a bulk load utility called bcp (at least that is what it used to be called). If you can get your data into a set of INSERT statements you can create a file that bcp can use. If your update operation is complex - referential constraints, lookups, unusual condition handling - you may be better served with a hybrid approach. You could load your data into a set of staging tables then process it with a stored procedure or program to get it into its final form. This last step has nothing to do with XSL but the overall approach is not that atypical: process your XML using XSL then let another more task-specific tool process the output. I have done exactly this with Oracle as the target but a Sybase-based approach would only differ in the detailed syntax.
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format