Care to share your command line for other's who might be trying to do this (of course edit out any sensitive info)?
On Fri, Nov 18, 2011 at 3:18 AM, Iulia Tamas <[email protected]> wrote: > 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 <[email protected]> > To: [email protected] > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- Zac Spitzer Solution Architect / Director Ennoble Consultancy Australia http://www.ennoble.com.au http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
