<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt"><div><span>Thank you very much for your answers! With your help, I have managed to set up the connection and copy .sdf to Oracle from command line</span></div><div><br><span></span></div><div><span>Iulia<br></span></div><div><br></div><div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"><div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"><font face="Arial" size="2"><hr size="1"><b><span style="font-weight:bold;">From:</span></b> djonio <DJonio@miami-airport.com><br><b><span style="font-weight: bold;">To:</span></b> mapguide-users@lists.osgeo.org<br><b><span style="font-weight: bold;">Sent:</span></b> Thursday, November 17, 2011 5:44 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapguide-users] Re: Fdo2Fdo tool<br></font><br>
As Dave notes you certainly require DB connectivity. I would recommend using<br>the latest instantclient. <br>This is how I go from Oracle TO sdf files...<br><br>Put something like these 3 lines in a bat/cmd file ... obviously fix'em for<br>your situation.<br><br>c:<br>cd \SDF_Conversions<br>"C:\FDO2FDO\7_7\Release\F2fcmd.exe" CopyTask test_copy_mv0_4.xml<br>------------------------------------<br>------------------------------------<br>The following are the contents of "test_copy_mv0_4.xml" shown above....<br><br><FdoCopyTask><br><br> <SourceConnection><br> <FdoProvider>King.Oracle.0.1.1</FdoProvider><br> <br><FdoConnectionString>Username=GISMIA;Password=;Service=MAPGUIDE;OracleSchema=GISMIA;</FdoConnectionString><br> </SourceConnection><br><br> <DestinationConnection><br> <FdoProvider>OSGeo.SDF.3.2</FdoProvider><br>
<br><FdoConnectionString>File=C:\SDF_Conversions\mv0_4_floorplan.sdf;</FdoConnectionString><br> </DestinationConnection><br><br> <ClassCopyDefinition><br> <SourceClassName>KingOra:GISMIA~MV0_4~GEOMETRY</SourceClassName><br> <br><DestinationClassName>KingOra:GISMIA~MV0_4~GEOMETRY</DestinationClassName><br> <CopyFilter></CopyFilter><br> <PropertyCopyDefinition><br> <SourcePropertyName>MVID</SourcePropertyName><br> <DestinationPropertyName>MVID</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>ID</SourcePropertyName><br> <DestinationPropertyName>ID</DestinationPropertyName><br>
</PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>ALTKEY</SourcePropertyName><br> <DestinationPropertyName>ALTKEY</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>VALIDFLG</SourcePropertyName><br> <DestinationPropertyName>VALIDFLG</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>NAME</SourcePropertyName><br> <DestinationPropertyName>NAME</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br>
<SourcePropertyName>FLOOR</SourcePropertyName><br> <DestinationPropertyName>FLOOR</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>SRCNAME</SourcePropertyName><br> <DestinationPropertyName>SRCNAME</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>LAYER</SourcePropertyName><br> <DestinationPropertyName>LAYER</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>AREASQFT</SourcePropertyName><br>
<DestinationPropertyName>AREASQFT</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>PERIMETERFT</SourcePropertyName><br> <DestinationPropertyName>PERIMETERFT</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>TXTCONTENTS</SourcePropertyName><br> <DestinationPropertyName>TXTCONTENTS</DestinationPropertyName><br> </PropertyCopyDefinition><br> <PropertyCopyDefinition><br> <SourcePropertyName>GEOMETRY</SourcePropertyName><br> <DestinationPropertyName>GEOMETRY</DestinationPropertyName><br>
</PropertyCopyDefinition><br> </ClassCopyDefinition><br><br> <CopyTaskAttributes><br> <ExecuteApplySchema>TRUE</ExecuteApplySchema><br> <ApplySchemaXMLFile></ApplySchemaXMLFile><br> <CreateSpatialContext>TRUE</CreateSpatialContext><br> <SpatialContextXMLFile></SpatialContextXMLFile><br> <MagicClassName>TRUE</MagicClassName><br> <MagicDataTypes>TRUE</MagicDataTypes><br> <DeleteDestinationData>TRUE</DeleteDestinationData><br> </CopyTaskAttributes><br><br> <CopyToSDFAttributes><br> <SDF_CreateFileIfMissing>TRUE</SDF_CreateFileIfMissing><br> <SDF_OverwriteFile>TRUE</SDF_OverwriteFile><br> </CopyToSDFAttributes><br><br> <CopyToOracleAttributes><br>
<Oracle_SRID></Oracle_SRID><br> </CopyToOracleAttributes><br><br></FdoCopyTask><br>---------------------------------------------------<br><br>.... this XML was produced from the GUI tool. I am way to lazy to write such<br>stuff myself.<br>r,<br>dennis<br><br>--<br>View this message in context: http://osgeo-org.1803224.n2.nabble.com/Fdo2Fdo-tool-tp7003610p7004527.html<br>Sent from the MapGuide Users mailing list archive at <a target="_blank" href="http://Nabble.com">Nabble.com</a>.<br>_______________________________________________<br>mapguide-users mailing list<br><a ymailto="mailto:mapguide-users@lists.osgeo.org" href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>http://lists.osgeo.org/mailman/listinfo/mapguide-users<br><br><br></div></div></div></body></html>