Hi Vaclav !
I think it is not necessary to check our model, as the problem depends not on the model. Can be tested with any example model.
To be more precise:
1.What do we want
We have a db model for mssql 2008.
The model contains a schema named “sysadm”.
When generating the ddl script, we want the output to have the line
“create schema “sysadm” …” like toad does it for oracle, pg etc.
What is the problem
If you edit the properties for the schema object in the mssql model, you will find, that there is no “Generate” checkbox to enable schema creation.
Our internal solution (not working)
First we created a makro, which sets the “GenerateCode” property for the schema object. Second, we enabled the “schema selection” in the DDL creation dialog via “OTP settings…”. When creating the ddl script, we checked the “schema” object.
After ddlcreation, the schema creation line is still missing.
For this internal solution, we do not need any help/supply.
If possible we want to know how toad creates the schema in the “normal” way.