{"id":15753,"date":"2023-10-20T06:00:12","date_gmt":"2023-10-20T06:00:12","guid":{"rendered":"https:\/\/www.directimpactsolutions.com\/?p=15753"},"modified":"2025-05-01T03:10:50","modified_gmt":"2025-05-01T03:10:50","slug":"identify-tables-fields-not-migrated-dmt","status":"publish","type":"post","link":"https:\/\/www.directimpactsolutions.com\/en\/identify-tables-fields-not-migrated-dmt\/","title":{"rendered":"How to Identify Tables & Fields Not Migrated via DMT"},"content":{"rendered":"

The FileMaker Data Migration tool (FM DMT) is a great tool that helps developers conduct deployments. To learn how to use the FM DMT, check out our video here: FileMaker Best Practices: The Data Migration Tool<\/a>.<\/p>

After using the FM DMT to migrate data from one file to another, it is a good practice to check the summary at the end to spot issues.<\/p>

\"\"
Migration summary<\/span><\/figcaption><\/figure><\/div>

Sometimes, we will find a certain number of tables or fields not migrated. Don\u2019t panic! This article will discuss identifying which tables and fields are not migrated and what to do afterward.<\/p>

\"\"
Some tables and fields are not migrated<\/figcaption><\/figure><\/div>

Run the DMT in Verbose Mode<\/h2>

If the previous run was not in verbose mode (with the -v option), do the DMT again, but this time, turn on verbose mode. This will generate a much more detailed migration log that will tell us what worked and what didn\u2019t.<\/p>

See the sample command below. Note the \u201c-v\u201d at the end, indicating it will run in the verbose mode this time.<\/p>

FMDataMigration -src_path \"SourceFile.fmp12\" -src_account \"source account\" -src_pwd \"source password\" -clone_path \"CloneFile.fmp12\" -clone_account \"clone account\" -clone_pwd \"clone password\" -v<\/code><\/pre>
After running the DMT in verbose mode, I suggest copying the detailed log out of the command line tool and into a text editor for easy search.<\/p>
Identify Tables Not Migrated<\/h2>
The easiest way to find tables not migrated is to search for the phrase \u201cNo target found for source table.\u201d This should help you locate tables in the source file, but not the target.<\/p>
\"\"
Use a text editor to find tables not migrated<\/figcaption><\/figure><\/div>
Note that sometimes after performing recovery on a file, FileMaker will automatically generate tables named \u201cRecovery XXX.\u201d If you have performed recovery on your target file, it might cause these recovery tables not to migrate, which is not a big deal.<\/p>
Data schema changes might result in tables not getting migrated, such as deleting tables in your target file but not in your source file, and creating tables in the source but not the target.<\/p>
Identify Fields Not Migrated<\/h2>
The easiest way to find tables not migrated is to search for the phrase \u201cNo compatible target.\u201d This will help you find fields in the source but not the target.<\/p>
\"\"
Use a text editor to find fields not migrated<\/figcaption><\/figure><\/div>
To see which table this field belongs to, scroll up until you find the closest \u201c == Mapping fields in source table XXXX. \u201c<\/p>
Data schema changes, such as deleting fields in your target file or creating fields in your source, are the most common reasons for fields not being migrated.<\/p>
What to Do After Identifying Tables\/Fields Not Migrated<\/h2>
We want to identify these tables and fields to determine whether they hurt our migration\/deployment. Long story short, not all of them are bad. What we are looking for are things we didn\u2019t expect.<\/p>
Some changes will naturally cause tables and fields not to migrate. For example, if you intentionally delete a table or field in the target file, it\u2019s completely normal to have that table\/field not migrate from the source. However, deleting a table or a field is a rather big change. Be sure to use your DDR to do reference analyses and ensure that deleting this content won\u2019t cause a problem for your app.<\/p>
On the other hand, you might find things you didn\u2019t expect. Perhaps you find a table added to the source file by some developer, and due to miscommunication, you never knew about it. These surprises should warn developers to clarify the situation and possibly consider halting deployment, rolling back, and rescheduling deployment.<\/p>
One important lesson I learned (the hard way) is that in most situations, it\u2019s better to call for a rollback and reschedule the deployment than try to \u201ctough it through\u201d and do massive troubleshooting on the day of the deployment.<\/p>
What Can I Do to Avoid Surprises?<\/h2>
As a rule of thumb, if there are deployment-related activities we can do before the actual deployment, we do them before the deployment. We want to plan, test, and rehearse before the day of deployment to remove as much uncertainty as possible.<\/p>
Suppose I\u2019m facing a very important deployment (for example, some organizations require their FM app to have a very high uptime. So the downtime we need to do deployment could be very costly for them). In that case, I will do a dry run by going through the deployment procedures minus uploading the migrated file to the production environment. During this dry run, I would have used the FM DMT for data migration. So, if there were any potential surprises in there, I would have found them before the actual deployment and had plenty of time to deal with them.<\/p>
I hope this article can help you troubleshoot or, even better, prepare for smooth deployments.<\/p>","protected":false},"excerpt":{"rendered":"
The FileMaker Data Migration tool (FM DMT) is a great tool that helps developers conduct deployments. To learn how to use the FM DMT, check out our video here: FileMaker Best Practices: The Data Migration Tool. After using the FM DMT to migrate data from one file to another, it is a good practice to …<\/p>\n
  How to Identify Tables & Fields Not Migrated via DMT<\/span> Read More »<\/a><\/p>\n","protected":false},"author":11,"featured_media":15776,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","footnotes":""},"categories":[29],"tags":[],"class_list":["post-15753","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-low-code"],"uagb_featured_image_src":{"full":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min.jpg",1500,1000,false],"thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-150x150.jpg",150,150,true],"medium":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-768x512.jpg",768,512,true],"large":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-1024x683.jpg",1024,683,true],"1536x1536":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min.jpg",1500,1000,false],"2048x2048":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min.jpg",1500,1000,false],"woocommerce_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-300x300.jpg",300,300,true],"woocommerce_single":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-600x400.jpg",600,400,true],"woocommerce_gallery_thumbnail":["https:\/\/www.directimpactsolutions.com\/wp-content\/uploads\/2023\/10\/DMT-min-100x100.jpg",100,100,true]},"uagb_author_info":{"display_name":"Weihao Ding","author_link":"https:\/\/www.directimpactsolutions.com\/en\/author\/weihao-dingdirectimpactsolutions-com\/"},"uagb_comment_info":2,"uagb_excerpt":"The FileMaker Data Migration tool (FM DMT) is a great tool that helps developers conduct deployments. To learn how to use the FM DMT, check out our video here: FileMaker Best Practices: The Data Migration Tool. After using the FM DMT to migrate data from one file to another, it is a good practice to…","_links":{"self":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/15753","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/comments?post=15753"}],"version-history":[{"count":2,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/15753\/revisions"}],"predecessor-version":[{"id":19986,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/posts\/15753\/revisions\/19986"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media\/15776"}],"wp:attachment":[{"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/media?parent=15753"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/categories?post=15753"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.directimpactsolutions.com\/en\/wp-json\/wp\/v2\/tags?post=15753"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}