I am Teruhiro Komaki of frudens Inc.
When developing FileMaker, I think it is common to prepare the development environment separately from the production environment.
Also, after releasing the initial version of the system, the developer will modify the development environment and release it to the production environment at an arbitrary timing.
Therefore, when releasing, it is necessary to migrate the data in the production environment to the Clone file of the development environment (Data Migration).
In the past, it is probable that many developers themselves create data migration tools themselves, rehearse in advance, and do release work.
Or you may be using RefreshFM etc.
However, as you can see in this title, I think that there are more cases to use the CLI tool FMDataMigration from now on.
FMDataMigration is a CLI tool available when subscribing to FileMaker Developer Subscription (FDS).
For details, it is good to look at the link below.
FileMaker Developer Subscription
Introducing FileMaker 17’s FMDataMigration Command Line Tool
FileMaker Data Migration Tool Guide
Be careful with FMDataMigration
I have not confirmed all cases, but …
- When moving a table with file separation
- Global field value
- Even if you set NOT NULL it will be imported
I think that it is necessary to pay sufficient attention to the files generated by FMDataMigration, and I think that our own data migration tool is necessary.
When FMDataMigration feels inconvenient
There is no problem if it is one file and two files, but in the case like the following, it makes me feel inconvenient indeed.
- When the file is full
- When there is a directory
At times like this …
Perhaps those who can do FileMaker will make FileMaker tools for efficient use of FMDataMigration.
Perhaps shell scripts will make shell scripts with tools to efficiently use FMDataMigration.
Since I am studying Go, I created it in Golang this time.
The goFMDataMigration created this time is a tool that will do something nice if you pass the account name and password as arguments.
When there are many files or there is a directory, I think that it can be used conveniently.
I created a demonstration movie so I think you can understand it if you can see it.
GoFMDataMigration has been released
I published it to Github, so please try using everyone.
As I recently just started go language, I think that the code is terrible …
I will continue to write Golang!