I don't have an answer to the question you asked...but FWIW...
I pushed an ERP system (71 tables, >500K records total and a relationship graph from ***) from 11 to 13 in about an hour......
you might find it easier to upgrade than to get them to talk to each other.
FMP6 to FMP7 was a nightmare..... .fmp11 to .fmp12 was so easy I almost blinked and missed it...
For this client they have thousands of users and hundreds of databases. There's a reason not all of the databases are upgraded and although the physical upgrade is easy, it's getting the software into all the end users computers, configured etc. Some are employees, others are subcontractors or outside agencies etc.
Also because so many of the systems talk to each other, it's not a matter of upgrading 1 system, it's a matter of upgrading 100's of systems. So we're trying to develop a practical bridge so that we can roll individual databases and systems up to their newer server without all the other issues of this mass migration for thousands of users and hundreds of databases all at once.
You can't use it as ESS-source, but the Import and Execute SQL script-steps do work. I even had 13 talking to FMS 5.5.
Thanks Otmar, this will probably get me around a chunk of what I need. This is probably what we did in filemaker 7 and just didn't remember, so spoiled with ESS.
I was considering using restfm as an option, and that may get me the balance of what we need, however that's a lot more involved. But it's such a big client and if we can get some of these smaller systems over utilizing this trick we can get it down to a manageable number to then roll the balance on a long weekend or over Christmas or something.
You can also use the XML interface to move data to and from with the additional benefit that you can run script in the target db that way...
Thanks so much for that added information. The one comment I have with this method is how do I script that. I don't see the option in script editor to do import records -> XML Data Source.
Manually I can do this, but I don't see how to put it into a script to choose an xml data source.
File menu > Import Records > XML Data Source.
2 of 2 people found this helpful
look at the Import (script step) dialog again. You can choose XML and additional dialog(s) appear.
the format/grammar of XML (export as FMPXMLRESULT) to import has not changed.
1 of 1 people found this helpful
You can also do an "insert from url" to get data and run a script (including passing parameters to the script).
Any data that you receive that way will end up as XML in the target field that you specify as part of the "insert from url"
You can then parse the data manually or with the help of a plugin and create / update the records that need it.