What are the challenges you face when working across database platforms? Take the survey
Options

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

I have a scripts folder containing
c:\myproject\mydatabaseuser\tables\table_a.sql
c:\myproject\mydatabaseuser\data\table_a_data.CSV  (created by source control)

The second scripts folder does not contain the table and the data (it is a new table that must be added). It is possible data compare to create the deployment script ( I checked at options "take a schema from the source" and I got nothing)?
Tagged:

Best Answer

  • Options
    Alex BAlex B Posts: 1,146 Diamond 4
    Answer ✓
    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.
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?

Answers

  • Options
    nikos74nikos74 Posts: 10 New member
    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.
Sign In or Register to comment.