File types

• 
  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

  Alex B August 17, 2018 12:00

  - 0 +
• 

  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.

  David Atkinson August 17, 2018 12:04

  - 0 +
• 

  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

  teltest August 17, 2018 15:58

  - 0 +
• 
  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.

  David Atkinson August 17, 2018 16:04

  - 0 +
• 

  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.

  teltest August 22, 2018 08:22

  - 0 +

Add comment

Please sign in to leave a comment.