Creating script for inserting data at static data table from data compare between two script folders

• 
  What version are you seeing this on and can you put a screenshot or elaborate a bit more on what you are doing and trying to achieve?  I've just checked in 5.7.4 and 5.7.6 and when I compare a script folder created by Source Control for Oracle for a table with some static data linked and compare that to an empty folder using the "take schema from the source" it will both update the target scripts folder and also create an insert script (in both cases it is only for the data, no schema included).
  
  I do notice you indicate the data script is called table_a_data, but for me it's just table_a.sql (in the tables folder) and table_a.csv (in the data folder), so I'm not sure why there is that discrepancy.
  

  Alex B July 06, 2020 08:37

  - 0 +
• 
  At the target folder there was the file StaticDataSettings.xml that copied by the source folder. Removing the 
  
  

  <value version="1" type="SerializedDataTablesRecord">

        <DatabaseObject version="1" type="DatabaseObject">

          <Name>TABLE_A</Name>

          <Owner>mydatabaseuser</Owner>

          <ObjectType>Table</ObjectType>

        </DatabaseObject>

        <Selected>False</Selected>

      </value>

  Deployment script was created after the finish of the data compare.

  nikos74 July 09, 2020 12:15

  - 0 +

Add comment

Please sign in to leave a comment.