I think David intended his reply to this message:
*Van:* David Lee *Verzonden:* donderdag 13 februari 2014 18:16 There is a good discussion on this in LinkedIn http://www.linkedin.com/groups/I-m-interested-in-transitioning-1947986.S.5797375269631184896?qid=bd6e9f6e-2e6c-419f-b524-9d808f02997e&trk=groups_most_popular-0-b-ttl&goback=%2Egmp_1947986 Its not MarkLogic or SQLServer specific but has some good ideas. #1 is to think first about your data model. You do *not* want to just mirror the table structure into an identical XML structure. After working out your data model there are a plethra of tools to do the actual transfer. My bias of course is xmlsh http://www.xmlsh.org/CommandXsql add a little scripting you can stream data from any SQL server, transform it on the fly and then insert it into ML with http://www.xmlsh.org/MarkLogicPut *Van:* [email protected] [mailto: [email protected]] *Namens *Johnson, Christopher Galle S. (CDC/ONDIEH/NCCDPHP) (CTR) *Verzonden:* donderdag 13 februari 2014 16:53 *Aan:* [email protected] *Onderwerp:* [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] WFH Fridays Phone: (787) 345-1195
_______________________________________________ General mailing list [email protected] http://developer.marklogic.com/mailman/listinfo/general
