asked on

Convert .sql to .tab

Hello Everyone,

I’m trying to export the DDL for each schema from TOAD to Subversion, by object type. For example, I’m exporting all the table creation scripts for a particular schema. However, the default extension for the scripts created is “.sql”. Our guidelines suggest “.tab”. I need to override the default to create scripts with the “.tab” extension. How can this be done?

Thanks for the help.

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MikeOM_DBA

...Our guidelines suggest “.tab”.

So you invent guidelines completely different from the standards?
Why then complain if it makes it difficult for you to follow your own guidelines?
If you live by your own standards, you die by your own standards.
:p

SOLUTION

capturetheflag

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

capturetheflag

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for capturetheflag's comment #a38913472

for the following reason:

Good answer!

slightwv (䄆 Netminder)

I'm afraid I'll have to object to you accepting your own answer as the only solution. Did it not use information from a previous post? The logic you posted looks pretty much like what I suggested.

I did not see the requirement of every table being in it's own script file in the original question.

MikeOM_DBA

I completely agree with slightwv,

capturetheflag's solution not only seems to be a copy/paste from somewhere else, but is based on slightwv's suggestion.

capturetheflag

ASKER

thanks