Take backup of my Vertica database

Moderator: NorbertKrupa

Post Reply
mavericky10
Newbie
Newbie
Posts: 4
Joined: Sat Dec 20, 2014 2:06 pm

Take backup of my Vertica database

Post by mavericky10 » Sat Dec 20, 2014 5:22 pm

Hi,
Is there a way to backup a Vertica database and restore it in SQL Server ? Or is there a way I can access a Vertica database from SQLServer?

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Take backup of my Vertica database

Post by NorbertKrupa » Sun Dec 21, 2014 1:17 am

There is no way to backup/restore from Vertica to SQL Server. You can always dump your entire database into flat files and use the SQL Server Import Wizard.

Otherwise, you can create a linked server to Vertica and query from SQL Server.
Checkout vertica.tips for more Vertica resources.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Take backup of my Vertica database

Post by id10t » Sun Dec 21, 2014 10:03 am

Hi!

[DELETED]
Last edited by id10t on Mon May 04, 2015 9:08 pm, edited 1 time in total.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Take backup of my Vertica database

Post by NorbertKrupa » Sun Dec 21, 2014 8:21 pm

id10t wrote:One one of my ex-customers reports that "Linked Server" works better than "ODBC_Loader", i.e. query Vertica from MSSQL works better(faster) than to query MSSQL from Vertica via ODBC_Loader.
Wow. Good to know.
Checkout vertica.tips for more Vertica resources.

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Take backup of my Vertica database

Post by id10t » Mon Dec 22, 2014 12:02 pm

Hi!

[DELETED]
Last edited by id10t on Mon May 04, 2015 9:07 pm, edited 1 time in total.

Post Reply

Return to “New to Vertica”