Alexander- The stored procedure joins to a ridiculous amount of different tables, typically grabbing a small amount of data from each. There is one table that holds the "main" list of items, with its primary key and name. These items have relationships with both parent and child tables.
We are condensing a normalized Db into lots of denormalized "documents" in MarkLogic. John C From: [email protected] [mailto:[email protected]] On Behalf Of Alexander Pericic Sent: Thursday, February 13, 2014 11:07 AM To: MarkLogic Developer Discussion Subject: Re: [MarkLogic Dev General] Migrate data from SQL Server to MarkLogic 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]<mailto:[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]> [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]<mailto:[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
