[mapguide-users] Re: Fdo2Fdo tool

[Iulia Tamas]

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

Iulia



________________________________
From: djonio <DJonio at miami-airport.com>
To: mapguide-users at lists.osgeo.org
Sent: Thursday, November 17, 2011 5:44 PM
Subject: [mapguide-users] Re: Fdo2Fdo tool

As Dave notes you certainly require DB connectivity. I would recommend using
the latest instantclient. 
This is how I go from Oracle TO sdf files...

Put something like these 3 lines in a bat/cmd file ... obviously fix'em for
your situation.

c:
cd \SDF_Conversions
"C:\FDO2FDO\7_7\Release\F2fcmd.exe" CopyTask test_copy_mv0_4.xml
------------------------------------
------------------------------------
The following are the contents of "test_copy_mv0_4.xml" shown above....

<FdoCopyTask>

  <SourceConnection>
    <FdoProvider>King.Oracle.0.1.1</FdoProvider>
  
<FdoConnectionString>Username=GISMIA;Password=;Service=MAPGUIDE;OracleSchema=GISMIA;</FdoConnectionString>
  </SourceConnection>

  <DestinationConnection>
    <FdoProvider>OSGeo.SDF.3.2</FdoProvider>
  
<FdoConnectionString>File=C:\SDF_Conversions\mv0_4_floorplan.sdf;</FdoConnectionString>
  </DestinationConnection>

  <ClassCopyDefinition>
    <SourceClassName>KingOra:GISMIA~MV0_4~GEOMETRY</SourceClassName>
  
<DestinationClassName>KingOra:GISMIA~MV0_4~GEOMETRY</DestinationClassName>
    <CopyFilter></CopyFilter>
    <PropertyCopyDefinition>
      <SourcePropertyName>MVID</SourcePropertyName>
      <DestinationPropertyName>MVID</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>ID</SourcePropertyName>
      <DestinationPropertyName>ID</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>ALTKEY</SourcePropertyName>
      <DestinationPropertyName>ALTKEY</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>VALIDFLG</SourcePropertyName>
      <DestinationPropertyName>VALIDFLG</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>NAME</SourcePropertyName>
      <DestinationPropertyName>NAME</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>FLOOR</SourcePropertyName>
      <DestinationPropertyName>FLOOR</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>SRCNAME</SourcePropertyName>
      <DestinationPropertyName>SRCNAME</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>LAYER</SourcePropertyName>
      <DestinationPropertyName>LAYER</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>AREASQFT</SourcePropertyName>
      <DestinationPropertyName>AREASQFT</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>PERIMETERFT</SourcePropertyName>
      <DestinationPropertyName>PERIMETERFT</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>TXTCONTENTS</SourcePropertyName>
      <DestinationPropertyName>TXTCONTENTS</DestinationPropertyName>
    </PropertyCopyDefinition>
    <PropertyCopyDefinition>
      <SourcePropertyName>GEOMETRY</SourcePropertyName>
      <DestinationPropertyName>GEOMETRY</DestinationPropertyName>
    </PropertyCopyDefinition>
  </ClassCopyDefinition>

  <CopyTaskAttributes>
    <ExecuteApplySchema>TRUE</ExecuteApplySchema>
    <ApplySchemaXMLFile></ApplySchemaXMLFile>
    <CreateSpatialContext>TRUE</CreateSpatialContext>
    <SpatialContextXMLFile></SpatialContextXMLFile>
    <MagicClassName>TRUE</MagicClassName>
    <MagicDataTypes>TRUE</MagicDataTypes>
    <DeleteDestinationData>TRUE</DeleteDestinationData>
  </CopyTaskAttributes>

  <CopyToSDFAttributes>
    <SDF_CreateFileIfMissing>TRUE</SDF_CreateFileIfMissing>
    <SDF_OverwriteFile>TRUE</SDF_OverwriteFile>
  </CopyToSDFAttributes>

  <CopyToOracleAttributes>
    <Oracle_SRID></Oracle_SRID>
  </CopyToOracleAttributes>

</FdoCopyTask>
---------------------------------------------------

.... this XML was produced from the GUI tool. I am way to lazy to write such
stuff myself.
r,
dennis

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Fdo2Fdo-tool-tp7003610p7004527.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20111117/13a0bfaf/attachment.html