No announcement yet.

Data Transfer missing Truncate Table option

  • Filter
  • Time
  • Show
Clear All
new posts

  • Data Transfer missing Truncate Table option

    When doing Data Transfer from table A to table B, it's all good if table A doesn't exist or it can be dropped and re-created during the transfer. However, if table B does exist and we want to keep its structure but not the content, it's harder. The Options tab does not have an option Truncate target table so this step would need to be done manually for all target tables involved. I come across this issue every time I need to fill my development database with a fresh sample of data from production. Please consider adding a checkbox option Truncate target table before creating records under Create Records or Other Options.

    Click image for larger version

Name:	nav.png
Views:	1
Size:	98.2 KB
ID:	5250

  • #2
    Hi tkimovski,

    Thanks for your suggestion. I have forwarded it to our development team. We will keep improving Navicat in future.