goFMDataMigration (CLI tool for easy execution of FMDataMigration) has been released

Hello.
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).

About DataMigration

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.

About FMDataMigration

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
https://store.filemaker.com/product/FDS

Introducing FileMaker 17’s FMDataMigration Command Line Tool
https://www.soliantconsulting.com/blog/fmdatamigration-command-line-tool

FileMaker Data Migration Tool Guide
https://fmhelp.filemaker.com/docs/edition/en/migration/index.html

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.

About goFMDataMigration

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.

Demo goFMDataMigration

GoFMDataMigration has been released

I published it to Github, so please try using everyone.

https://github.com/frudens/gofmdatamigration

Afterword

As I recently just started go language, I think that the code is terrible …

I will continue to write Golang!

I am a Japanese developer. (I am studying English.) I met the FileMaker Platform at the company I worked at the time. Develop a custom App as an in-house developer. Acting as freelance from 2014 and establishing frudens Inc. in 2016. Recently, I use 'Insert From URL'. I enjoy FileMaker and various services in Integration!

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.