Hi John - Apropos the output of your stored procedure... Does it output each record from an SQL table as its own XML file, how is that handled?
Thanks, Alexander P ________________________________ From: [email protected] [[email protected]] on behalf of John Chertudi [[email protected]] Sent: Thursday, February 13, 2014 8:17 AM To: MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] Migrate data from SQL Server to MarkLogic I wouldn't call it migration per se, but we store a copy of 5 million documents in MarkLogic, consolidated from a few thousand smaller SQL databases. This allows us to search the text of all those distributed SQL databases. We use a fairly complex SQL stored procedure including the "FOR XML" statement to format it into XML that can be sent to an http app server on MarkLogic. John C From: [email protected] [mailto:[email protected]] On Behalf Of Johnson, Christopher Galle S. (CDC/ONDIEH/NCCDPHP) (CTR) Sent: Thursday, February 13, 2014 7:53 AM To: [email protected] Subject: [MarkLogic Dev General] Migrate data from SQL Server to MarkLogic Has anyone migrated data from SQL Server to MarkLogic? Can you point me in the direction of some documentation? Thanks. ________________________________________ Christopher G.S. Johnson Software Development Analyst 3/DBA Northrop Grumman, NCCDPHP Contractor Centers for Disease Control and Prevention (CDC) Phone: (404) 679-9486 E-mail: [email protected]<mailto:[email protected]> WFH Fridays Phone: (787) 345-1195
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
