Does the Import Utility Wizard append or overwrite information? (33632)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Does the Import Utility Wizard append or overwrite information?
Description

Does the Import Utility Wizard append or overwrite data when importing tables? I exported multiple tables using Export Utility Wizard and am now trying to import the .dmp file to update my database. I am weary of duplicate data if I import into an existing table.
Resolution

Import Utility Wizard's import table will append data.

If you do not have unique values constraints it you can get duplicate data. If duplicates is a problem, truncate data from the table before importing.

Feedback submitted.

Was this article helpful?

[Select Rating]

Title