locked
SSMA generates TRUNCATE TABLE statements for data migration, want DELETE instead RRS feed

  • Question

  • The SQL Server Migration Assistant generates TRUNCATE TABLE statements for migrating data.   However , TRUNCATE requires ddladmin privs.  Can I change it so it generates DELETE instead? DELETE only needs datawriter privs
    Tuesday, March 8, 2016 8:38 PM

Answers

  • Hi G Britton,
    What type of database do you migrate data to SQL Server?

    Based on my search, there isn’t a feature or project setting in SQL Server Migration Assistant (SSMA) for access to generate DELETE statement, could you manually change the TRUNCATE statement to delete statement?

    Also, when you migrate data from Oracle to SQL Server, if you have selected “Using INSERT, UPDATE, DELETE statement” for Conversion ways of MERGE statement in SSMS, it will generate the DELETE statement.

    Reference:https://msdn.microsoft.com/en-us/library/hh313192(v=sql.110).aspx

    Friday, March 11, 2016 10:30 AM