File types

teltest

I am using Schema Compare to create a file per object. Each file has the extension .sql
Is there a way to get the table creation files to have .tbl, triggers to have .trg, procedures to use .prc etc?

Alex B

Hi @teltest,

Unfortunately there is not a way to change the extension that the scripts files are created with.  Our create the files in the format they need to be created.

They do section the objects in different folders so you all tables are contained together for example and so you could easily rename them with a PowerShell script, though doing this will cause the files not to be recognized in our tool.

Kind regards,
Alex

David Atkinson

teltest said:

I am using Schema Compare to create a file per object. Each file has the extension .sql
Is there a way to get the table creation files to have .tbl, triggers to have .trg, procedures to use .prc etc?

I'd be curious to know why you have this requirement.

teltest

David Atkinson said:

I'd be curious to know why you have this requirement.

Hi David,
We use PL/SQL Developer (from allroundautomations) for our development. This uses a different extension per object type. We will be using Schema Compare to generate the code from our Live database.  This will be source controlled. We would then branch from there to a development area.
I have taken Alex's suggestion and modified my batch file to change the file extensions from fnc, prc, etc to sql before performing the Compare and then changing them back afterwards. It seems to work fine.
Many thanks for your quick response.
Terry

David Atkinson

Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control without even having to consider the files at all.

teltest

David Atkinson said:

Are you using Source Control for Oracle? If you use this, you can make changes directly to the database objects in PL/SQL Developer, and check them in to source control without even having to consider the files at all.

I have looked at Source Control for Oracle. We are currently using TFS more as a backup and not as a release mechanism.  When we start to use Source Control as a release pipeline then this might be of more use.