Is there a Compatibility level option in Vertica?

Moderator: NorbertKrupa

Post Reply
sarah
Intermediate
Intermediate
Posts: 77
Joined: Mon Aug 27, 2012 1:34 pm

Is there a Compatibility level option in Vertica?

Post by sarah » Thu Jan 09, 2014 4:54 pm

Hi,

SQL Sever has a nice option called "Compatibility level" which lets me run the DB is a mode compatible with SQL Server 2005 (90), SQL Server 2008 (100), or SQL Server 2012 (110).

Forgive me if this is too stupid of a question, but is there a similar option is Vertica? So, if I have Vertica 7 installed on a dev server, but 6.1 in prod, can I run the dev db in 6.1 mode to a release to prod?
Have a GREAT day!

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Is there a Compatibility level option in Vertica?

Post by JimKnicely » Fri Jan 10, 2014 10:11 pm

Hi Sarah,

I do not believe there is a way to make a Vertica DB run as an older version. I'd imagine it'd be really, really complicated in Vertica from an engineering perspective.

Maybe you can use one of the Vertica VMs provided on the 6.1 DL page for your testing?

https://my.vertica.com/hp-vertica-enter ... ads-6-1-x/

The VMs are in the "Download HP Vertica 6.1SP3 (6.1.3) Virtual Machines" section of the page.
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica Database Administration”