Vertica Blog

Vertica Blog


Vertica’s Server-Based Replication

Empowering Seamless Data Copying in Vertica Eon Mode Overview In our latest installment of exploring the untapped potential of Vertica, we delve into the exciting new feature introduced in version 23.3 - Server-Based Replication. This cutting-edge functionality allows users to efficiently copy data from one Eon Mode database to another, revolutionizing the way data replication...
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...