Any way to override "Generate Script" options?
Joined: 05 May 2013
Topic: Any way to override "Generate Script" options?
Posted: 15 Mar 2017 at 1:38am
I'm using data modeler with MSSQL 2008 R2.
I generate scripts for "everything" (all options checked).
I take the generated script and use them with dbExpress and TSQLQuery.
That is, I set SQLQuery.SQL and then do an ExecSQL.
The scripts as generated don't work - I have to change "GO" to ";" unless I'm working with management studio...
Is there a way to change the output of Generate Script to eliminate changing all the "GO" entries?
Also, when a trigger is first created, I have to modify it from
CREATE TRIGGER <%TriggerName%> FOR <%TableName%>
CREATE TRIGGER <%TriggerName%> ON <%TableName%>
(and I usually forget that). I don't imagine there's an option to use "ON" instead of "FOR"?
Wagner R. Landgraf
Joined: 18 May 2010
|Post Options Quote Reply Posted: 15 Mar 2017 at 11:56am|
In current version there is no option to change those settings. What we're evaluating is the implementation of a script system that will allow users to customize several parts of Data Modeler, including SQL generation in this case.
|Forum Jump||Forum Permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum