Integration Studio: Import database,when does integration studio assign a new SS_KEY?

Integration Studio: Import database,when does integration studio assign a new SS_KEY?

  
1) A new SS_Key is assigned when you import a new entity table via integration studio import database feature; but what happens if you delete the entity and import the same entity again? will the same entity get the previously assigned SS_KEY or will it get a new SS_Key?

(Currently integration studio is unable to detect deleted database tables, it will assume the entity you imported previously will always be valid for a lifetime, that is not always the case, so what do you do to get around sync issue?)


Hi Robert,

If you delete and re-import it, it will have a new key. Keys are new guids generated at creation time.

I tested the delete table in the database and refresh.
It loses all attributes when the table does not exist (at least in mssql), don't have a oracle/mysql here at the moment to test, but if the same happens on those, you can refresh and then delete only the invalid entities as that means they have been deleted in the database.




Regards,
João Rosado
Joao

I could verify that this is a bug found when importing and refreshing MySQL database tables (the feature to detect deleted table was  implemented in SQL Server but not implemented in MySQL Server)

In MySQL server, integration studio is unable to detect a deleted table, if you click on "Verify and save" or perform a refresh on the deleted table itself, integration studio will indicate that your extension is valid. (deleted table should not be considered valid!)


Joao

Strangely enough, if you hit publish outsystems service studio detects the table has been deleted. (It didn't delete on "verify and save", it detected a deleted table when "publish" is clicked, this is a different behaviour to SQL Server?)