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?
Take backup of my Vertica database
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Take backup of my Vertica database
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.
Otherwise, you can create a linked server to Vertica and query from SQL Server.
Checkout vertica.tips for more Vertica resources.
Re: Take backup of my Vertica database
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 9:08 pm, edited 1 time in total.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Take backup of my Vertica database
Wow. Good to know.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.
Checkout vertica.tips for more Vertica resources.
Re: Take backup of my Vertica database
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 9:07 pm, edited 1 time in total.