Specifying Filegroups

[Nicky Jones]

When putting a database design in, is there a way of specifying the filegroup to create the tables on?

Many thanks

[«Midnight»]

Check the Tagged Values window after you create the table. You might actually have to create a tagged value, but in this case I cannot say whether EA would recognize it and generate DDL (or for that matter, what name EA might recognize).

Look in the EA help index for Data Modeling | Set Oracle Table Properties. This does not handle your case, but it gives you an idea how EA goes about this kind of thing. I believe - but I am not sure, so check it out yourself - that EA does something similar for other DBMS engines.

Documentation for other (than Oracle) DBMS engines is vague or nonexistent. For example, with MySQL there is a Type tagged value that can be set to InnoDB. The documentation is vague though, and seems to confuse this with an ENGINE tagged value. My advice (as above) is to open the Tagged Value window and see if EA has created empty 'placeholder' tagged values for you. If so, and if you see the one(s) you want, then enter the values you need and see if EA generates DDL.

HTH, David

[Nicky Jones]

Thanks for that I will take a look at it and how it behaves.  I probably should have said it is for SQL Server 2005, that I am generate the DDL for.

[«Midnight»]

Hi again Nicky,

I know just what you mean. I work with SQL Server 2005 and 2008. There are certainly some values to help here, but they are opaque as far as the documentation is concerned.

David