Replication creates extra tables in the database

Replication creates extra tables in the database

In some cases, as a result of Replication, in addition to the main tables (for example, dbo.Account ), empty additional tables are created in the database with names of the following types:

dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52
dbo.Account_7c473919_0b04_4c82_a993_e8445843bac4
dbo.Account_8220931f_c341_45aa_a4ec_ddd3fce83936
dbo.Account_96dc6902_1dc6_413d_a206_f116f076130b  etc.

These are temporary tables that Skyvia creates during Replication, where data is temporarily transferred, and merged with the main table, after which these tables are deleted. The user should not see these tables, but if they do, there are two possible explanations:

1) Replication has not finished its work yet and that's why they have not been deleted yet, and when it finishes, it will clean up everything.
2) The user from his connection to the database, has no permissions to DROP TABLE operation and Replication can not delete them after itself. Then you need to give such rights to the user, and delete the already left tables manually.

In such cases, it is also recommended to update the Skyvia Agent. More details can be found via this link.

    • Related Articles

    • What is a record?

      The record is an element of the database. It is composed of fields and contains all the data about one particular person, company, or item in a database. Records appear as rows in database tables.

    • Understanding Records in Skyvia Data Integration

      1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process—Import, Replication, Export, Synchronization, etc —handles individual records. Records also serve ...