Test Data Manager

 View Only
  • 1.  Handling Identity Insert in Synthetic Data Generation

    Posted Jul 20, 2020 06:33 AM
    Hi Team,

    We are doing Synthetic Data generation for Database tables. When publishing data to tables that have Identity Inserts (SQL Server) for the primary key columns, the Publish fails.
    Is there any way to handle this.

    Thanks,
    Aadhavan


  • 2.  RE: Handling Identity Insert in Synthetic Data Generation
    Best Answer

    Posted Jul 20, 2020 10:46 AM
    Hi Aadhavan,


    Go to the registered objects->Select the table->Maintain Table->For columns which are auto generated set/check the computed? checkbox. This should be automatically handled by CA but they are not doing it. Once done save it and do the publish. Hope this solves the problem.

    ------------------------------
    Thanks,
    Rajkumar
    ------------------------------



  • 3.  RE: Handling Identity Insert in Synthetic Data Generation

    Posted Jul 22, 2020 09:14 AM
    Thanks Raj,I will check this and let you know.