Linked server to Ingres
Of late i have been working extensively with Ingres and Open Road maintaining old legacy applications. As part of up-gradation I frequently query and move data from Ingres to MS SQL SERVER using linked servers which connects using default ODBC drivers that come along with Ingres client installation.
Performance is appreciable and it also makes development a pleasure considering that you no longer have to work with flat files to move data in and out from Ingres.
I will be exploring more with linked servers trying to look for best methods/practises to integrate these 2 databases.
Advertisement
