File types
teltest
Posts: 12 Bronze 1
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?
Is there a way to get the table creation files to have .tbl, triggers to have .trg, procedures to use .prc etc?
Best Answer
-
Alex B
Posts: 1,158 Diamond 4
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
Answers
Product Manager
Redgate Software
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
Product Manager
Redgate Software