---
title: "Comment by Danny on \"Data Migration/Extraction from Autodesk Vault\" | Hashnode"
description: "Hi Andrew, Great article, really helped me to get started with inventor database. I recommend this article to my colleagues as well. I have few queries on this."
url: "https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/63a44fe53916c9c9a801cf29"
---

[Discussion](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53)

Comment [Data Migration/Extraction from Autodesk Vault](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53)

[Danny](https://hashnode.com/@danny448)

[Dec 22, 2022](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/63a44fe53916c9c9a801cf29)

Hi Andrew, Great article, really helped me to get started with inventor database. I recommend this article to my colleagues as well. I have few queries on this. Could you please me with these:

1) Could you please help me with where family table data is stored in inventor database.?

2) I see the count from filemaster table from the report you shared is 93,378. But in the end you have mentioned you have migrated 50,000 objects. So are the remaining is Non cad data or am I missing anything?

3) I really didn't understand the use of recursive CTE used on folder table, since vaultpath has already the folder structure for us. Could you please help me to understand why is this required?

[Andrew B](https://hashnode.com/@abowden)

[Dec 23, 2022](https://hashnode.com/posts/data-migrationextraction-from-autodesk-vault/6242a0a5db84f8c50fa5ba53/comment/63a44fe53916c9c9a801cf29#reply-63a4f504490dd1c9cd9c3c55)

Hi there, here are my answers to the questions:

1) Unfortunately our team didn't make use of family tables, so I'm unsure where it might be stored. One method I've used for something similar is to dump the entire DB to an SQL file and do a text search for a sample value that you're expecting and try to find which table/column it's located in

2) We filtered down the file counts to only include ipt, dwg and iam as we had as those were the only file types that were needed to migrate. There was a lot of other miscellaneous files (png, log, pdf) that weren't needed

3) The main use of the CTE was for us to determine the depth of the folders (which was needed by the destination system team and also aided in sorting) by counting the parent/child links. It could be done by counting the "/" character in the query but having the CTE didn't make a major performance difference: -6 seconds to execute with the CTE -3 seconds to execute without