none
Azure SQL Data Sync truncate table RRS feed

  • Question

  • I am trying to sync data from onprem to azure database

    if i truncate records in onprem and sync the records are still the same in azure

    i had to truncate table manually in azure

    then it works

    is that the correct approach? Do i need to trucate the trackiing tables too?

    Please let me know

    Thanks!

    Thursday, October 22, 2020 10:39 AM

All replies

  • A TRUNCATE isn't a DML command which produce data changes to sync, it is a DDL command and equals DROP Table + CREATE Table.

    So no data changes = nothing to sync.

    See What is SQL Data Sync for Azure? => How it works

    BTW, SQL Azure & SQL Server related moved to Question & Answer: https://docs.microsoft.com/en-us/answers/products/sql-server


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, October 22, 2020 12:12 PM
  • Hi SQLAzure678:

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum:

    https://docs.microsoft.com/en-us/answers/topics/azure-sql-database.html


    Regards, Obaid Farooqi

    Thursday, October 22, 2020 6:24 PM
    Owner