A generic tool/ workbench to convert multiple mdf files to gdb in ArcMap

If the .mdf files are MS SQL Server primary data files, you can use FME to read the database tables directly from SQL Server and write them to gdb, this is usually fairly easy. You should not be reading the mdf files directly.

Thank you David for your answer, I tried this solution but I faced another issue that the structure of my new file geodata base doesn’t look like the structure of mdf one.

Maybe I do something wrong, but my work bench contains a reader read from mdf & writer write into file geodatabase.

What do you think?

Best,

Rawan

Hi David,

I have an SQL data base “B” having 4 feature class, I tried to develop a workbench to transfer the mdf to file geodatabase . it’s transform the feature class from mdf to file gdb but the plygon feature class converted to points feature class .See below

What might be the issue here, what I’m missing in my workbench?

Best,

Rawan

Hi Again,

I’v appended the work bench if you can have a look on it.

Best,

Rawan

mdftogdb.fmw

Try changing the geometry types accordingly in the output feature types:

Dear David ,

Thank you, it’s working fine.

One more thing Is there any way to let the reader take the mdf data base contain without manual select for feature class?

Best,

Rawan

Try using a dynamic schema rather than a static one when generating the workspace:

You can read more about it here:

https://knowledge.safe.com/articles/1157/dynamic-workflow-tutorial-destination-schema-as-a.html

Dear David ,

Thank you, the link that you provided is very helpful

But I noticed that the workbench doesn’t transform all records in one of my feature class see below

Best,

Rawan

Hard to say why. Have a look in the FME log to see if there are any warnings or errors.