Usage of file migration options "Re-build Indexes" and "Use Fonts From"

[Joel]

I did not really find a detailed description in the documentation of OttoDeploy and Claris Help, therefore I ask this question here:

1. File Migration Option “Re-build Indexes” (used by Data Migration tool):
   According to official Claris documentation, it says it will “Rebuilds indexes from scratch”. For my understanding, this will affect all indexed fields on the database.

However, when does it make sense to use this option?

We recently performed multiple deployments using OttoFMS 4.6.1 / OttoDeploy 1.2.6 and noticed corrupt indexes for tables, where new fields have been added. We never experienced such a behavior in the past, however this option most likely could prevent it. Maybe, this issue is also related to a bug in the Data Migration tool itself.

2. File Migration Option “Use Fonts From” (used by Data Migration tool):
   According to official Claris documentation, it will “Check / don’t check the font mapping for field contents”.
   What is the impact of checking this option and when is it used?

Thanks.

[toddgeist]

Hello Joel

Welcome to the community

Setting The Rebuild Indexes option to true causes the Data Migration tool to rebuild indexes as it doing the migration, instead of just copying them. The setting affects the entire file. This will slow the migration down dramatically.

You might want to use it if you know that your indexes in the data source file are bad, or if they are going to be wrong because you have changed the data type for a field for example.

We are not aware of any bugs in the Data Migration tool. That doesn’t mean there isn’t one. But OttoFMS auto-migrated over 6200 FileMaker files last month alone, and we didn’t get any reports to suggest that.

The Use Fonts From setting is only used if you have styled text in your data. If you aren’t using styled text fields, this has no impact either way.

Let us know if that helps

Thanks

Todd