[Last Call] Learn how to a build a cloud-first strategyRegister Now


Export Schema for an FP7 DB.

Posted on 2006-03-21
Medium Priority
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

billmercer earned 1600 total points
ID: 16253804
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

lesouef earned 400 total points
ID: 16255000
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.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Screencast - Getting to Know the Pipeline

826 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