Toad World® Forums

After Script database statement delimiter


#1

Hello,

I have a MSSQL2008 physical model and in my after script on an entity I will have and insert statement:

insert into foo (column 1) values (value1)
go

When I convert this model to Oracle 10g I would like to have the insert statement look like

insert into foo (column 1) values (value1)
/

Is there a macro I can put at the end of the insert statement, something like
%DBTypeDelimiter% that will insert “go” when I generate the DDL Script for Sql Server. And then when I convert the model to Oracle 10g, insert the “/” when I generate the DDL Script for Oracle?

Thanks,

Greg


#2

Hi,

application variables will be available soon. Now you can write script that will change what you need. Get some inspiration here:
http://blogs.inside.quest.com/modeling/2009/02/04/script-to-remove-comments-after-conversion/

and feel free to download some scripts from here:
http://modeling.inside.quest.com/kbcategory.jspa?categoryID=35

Toad Data Modeler is customizable tool and many objects can be easily modified via scripting. If you need our help, please feel free to write us back.

Regards,

Vaclav