Topics

1

Automation Interface, Add-Ins and Tools / Generate separate DDL file for each table

« on: February 19, 2024, 11:51:44 am »

Hi all,

I am generating individual DDL script files for each table in my physical data model. But, this options prompts for the table name for each DDL that is being generated.
Can I write a script to automate the process, that is, a script that will take the table name and generate the DDL with same name as that of table? Anyone done it something similar, appreciate your help.

Regards,
Arun 

2

General Board / Attribute/Column lengths from Logical to Physical Data Model

« on: February 07, 2024, 02:49:25 pm »

Hi All,
In logical class model I have defined attributes and they do not have option to define the lengths.
For example, if my class name is Employee and EmployeeName is the attribute defined as VARCHAR, I don't see option to define the length say 100 Characters wide in logical model. I have defined the default database (SQL Server in my case) which has default lengths for each applicable datatypes. for example 50 for varchar, 10 for char, etc.
When I convert the Logical model to Physical, all the varchar attributes are converted to columns in the table as expected, but all are defaulted to a standard size 50.
My question is: Can I define attribute size in logical models? If the answer is NO, then I can define size in converted physical model but how to avoid the size getting overwritten next time?

Regards,
Arun