Question
Laura Cavanaugh · Dec 6, 2016

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?

Thanks,

Laura

0
0 424
Discussion (2)1
Log in or sign up to continue

is the import smart enough to figure out if a row already exists

As you can't specify an ID column during import, then no, SQL import wizard would only insert new rows.

is there some other utility that can check for keys first?

You can:

  • export/import underlying global(s)
  • use 3rd party SQL database explorers to generate UPDATE DDL statements from your data (DataGrip can do it for example), and then import this DDL into new namespace

OK, thank you; We'll have to take a look.