create table ?

[bertmaker]

Hi there, first post from a n00b in filemaker, hope the question isn't too dumb...

 

I'm a dba in mssql and oracle but as said new in filemaker. I'm wondering if it's possible to generate filemaker tables using a script à la http://msdn.microsoft.com/en-us/library/ms174979.aspx ? 

 

I would feel much more comfortable porting my solutions from development to test and later production by recreating the database/solution using a script.

 

 

 

But, perhaps my old ways made me blind; if this is a stupid idea can someone explain to me what would be the filemaker way of doing this?

 

 

Thanks in advance for your time,

 

Regards,

 

Bert

[Wim Decorte]

FM xDBC supports CREATE TABLE and ALTER TABLE, but it is not going to be a good approach for moving your solution between dev, test and production.  FileMaker Scripts and layouts use the underlying table and field IDs as internal references.  Those will break if you drop tables and add them externally.

You also don't have the full range of field options available to create through SQL.

 

A couple of options:

- if the data model is stable you can use the data separation model and just replace the UI/logic file

- or you import the production copy data into a clone of the development system