Web forum is in read-only mode. Login as active registered customer for write access
  Forum Search   New Posts New Posts

Any way to override "Generate Script" options?

 Post Reply Post Reply
Author
Blanchard Ed View Drop Down
Member
Member
Avatar

Joined: 05 May 2013
Posts: 47
Post Options Post Options   Quote Blanchard Ed Quote  Post ReplyReply Direct Link To This Post 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%>
to
CREATE TRIGGER <%TriggerName%> ON <%TableName%>

(and I usually forget that). I don't imagine there's an option to use "ON" instead of "FOR"?

Thanks!

Cheers,
EdB


Back to Top
Wagner R. Landgraf View Drop Down
TMS Support
TMS Support
Avatar

Joined: 18 May 2010
Posts: 2485
Post Options Post Options   Quote Wagner R. Landgraf Quote  Post ReplyReply Direct Link To This Post Posted: 15 Mar 2017 at 11:56am
Hi Ed,
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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down