Geeks With Blogs
Rahul Anand's Blog If my mind can conceive it, and my heart can believe it, I know I can achieve it.

I was looking for a feature in Ingre Vectorwise similar to ‘Linked Server’ in MS SQL Server and ‘Database Link’ in Oracle. But unfortunately it seems Ingre Vectorwise 2.5 does not offer anything similar.


The Ingres has ‘Register Table as Link’ (Ingres Star) which is currently not supported in Vectorwise. So I think the only available option as of today is to copy tables in one database on one server and then do the cross joins.


Another way would be to create linked servers in MS SQL Server to different instances/databases of Ingres Vectorwise, but this will be very inefficient solution. It may be ok for some manual data analysis.

Posted on Wednesday, February 13, 2013 9:15 AM Ingres Vectorwise | Back to top

Related Posts on Geeks With Blogs Matching Categories

Comments on this post: Can Vectorwise execute a query joining databases from multiple instances?

# re: Can Vectorwise execute a query joining databases from multiple instances?
Requesting Gravatar...
Passing Cisco exams require that you have a thorough understanding of the exam content. Because Cisco exams can cover several areas of technology each exam requires concentrated study as part of your preparation. Remember that you are studying for your future, not for an exam. Keep this in mind as you study and it will help you to stay on task and focused on the overall goal of achieving the certification.
Left by David on Feb 16, 2013 2:56 PM

Your comment:
 (will show your gravatar)

Copyright © Rahul Anand | Powered by: