Drop and recreate table option in syniti

ADMM has create working table and build table for S and T table. but we option for dropping those table in syniti itself, currently we are doing in sql sever

  • Guest
  • Nov 24 2023
Migrate
  • Attach files
  • Sebastian Di Grillo commented
    02 Jul 08:08

    Since new fields are added automatically into the ST and TT.

    And old fields are not removed from them.

    I believe that when someone specifically presses a button like "Create Target Tables" or "Built Table" or "Create Working Table" it is expecting to fully re-create the tables, therefore a DROP TABLE should be carried as first step.

    Alternatively, this could be added as an advance parameter "Drop tables before creating them".


    This would remove the need of going into the back end to manually to cleanup old fields or restoring the order of the fields when the Dataset design is modified.

    ×

    Attachments Open full size

Related ideas