Export Schema for an FP7 DB.

Posted on 2006-03-21
Last Modified: 2006-11-18
Never used Filemaker Pro before, but have been handed one with a schema I need to copy.

How can I view the schema so I can rebuild similar in another rdb?
Question by:smetterd
    LVL 19

    Accepted Solution

    FileMaker isn't SQL-based, and if you're used to SQL databases, you'll probably find some things very strange.
    What version of FileMaker are you using? It will make a big difference.

    You can use FM scripting to collect lots of information about the database, but since you've never used it before, that's probably not a good choice.

    The Advanced/Developer version of FileMaker has a feature for generating a database report that will include the information you probably need. If you just have the standard version, you can still get the same information, it's just a more tedious manual process. Basically, you go into Define Database, and choose to print field definitions for each table.
    LVL 28

    Assisted Solution

    May be a screen capture of the relationships would show most of it if there are not too many tables, and therefore shrinked on screen.
    I also recommand fmpro migrator as this guy is rather smart, is able to read filemaker native format, and restore a lot of things though SQL queries executed by a perl script.
    there is a demo version.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now