This application hasn’t got much attention yet, but it sure deserves some. Initially used as a test platform for Haris’ open source King.Oracle FDO provider, it has quickly evolved into a general purpose FDO data transfer and inspection toolkit.
Haris does a much better job of describing the functionality of this tool than I ever could in his flash movie. I really encourage you to have a look, but set your resolution to at least 1280×1024 for best viewing. As you’re watching, keep in mind that there is a command line utility included which can perform all of the common schema-related (ExportSchema, CreateDatastore, ApplySchema, CopyData) tasks. For usage you can just navigate to the isntallation folder and type
f2fcmd from the Windows command line.
The demo shows SHP, SDF, and Oracle as datastores, but you can easily add any FDO provider to the application. These include things like MySQL, ArcSDE 9.1, and (read-only) any OGR-supported data format. The utility of this application is simply outstanding.
If you paid attention to the movie (and know where I work) you’ll be able to figure out my personal interest in this tool. It has allowed the City to set up a low cost one-click data synchronization between a remote field application and a corporate database. All this required was the judicial use of the “Filter” option, some saved XML transfer tasks, and pre-defined schemas. One cool feature (that we didn’t use) is that you can apply geometry filters, allowing you to transfer a specific area of interest.
fdo2fdo is currently only available in a windows binary download (with Oracle instant client bundled, which is why it’s so big), but Haris has assured me that after he cleans up the code he will be submitting at least the command line and API code to the FDO SVN repository under an appropriate OSI-approved license. Haris is new to the open source world, but he’s catching on really fast.
I believe that the API and command line tool were coded in standard C++, so I’m hoping that they can be ported to Linux shortly after he uploads them. I’m also hoping that the GUI portion of the application will be uploaded. It’s apparently written in MFC, so there isn’t an easy translation to Linux. However, it could act as a model to help someone else build a Linux-based GUI.