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-5999726fb4d90636738475/] Take a backup of the existing Vertica Console: [crayon-5999726fb4d99067600773/] Upgrade the Vertica Console rpm [crayon-5999726fb4d9d850813708/]   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

Google Cloud SDK (gcloud)contains tools and libraries that enable you to easily create and manage resources on Google Cloud Platform. Installing Google Cloud SDK(gcloud) is quite simple and Google does all the work for you. you will need to run the following command logged as root user. [crayon-5999726fb7bcd471738561/] Restart...

Continue reading