migration sql server to vertica

This is a simple step by step Vertica Management Console upgrade guide. Before you start make sure you download the latest Version or Vertica Management Console from  my.vertica.com website. Here we go ! Stop the Vertica Console: [crayon-5a324e09a2238919159204/] Take a backup of the existing Vertica Console: [crayon-5a324e09a2242634012491/] Upgrade the Vertica Console rpm [crayon-5a324e09a2246853740313/]   Open...

Continue reading

Starting with Vertica version 7.2.x HP Vertica comes with a great feature called Inheritance, this concept is similar to SQL Server schema roles that will dynamic propagate the privileges across all objects in the schema and associate them with the users that have access to...

Continue reading

When you go thru regular database maintenance you might need to drop some objects. In some cases this objects have dependencies, this is the case of Sequences. So this is the error you get when you try to drop a sequence and that sequences is used in...

Continue reading

Migrate one Schema fast and dirty from one Vertica Cluster to another. This approach is used when : you don't have Vertica Cluster configuration the same in both Clusters and copy cluster won't work. no INBOUND access is available to the source Vertica Database(Production security needs...

Continue reading