Question about table export and import (NOT just how to do it)
Hello. When you export and then import a table of data, is the import smart enough to figure out if a row already exists in the new namespace, and if so update the row rather than just save/add the row?
For example, we have a table in DEV, and the same table in QA. The DEV table has more fields than QA. When we moved up the class, the field definitions went with the table into QA, so now the table definition is the same in both.
We need to export the data from DEV and import it into QA, but file each row in QA as an existing row, and just update its data. Is the SQL Export/Import Wizard smart enough for this? is there some other utility that can check for keys first?