From: Brian J. Hoppe <brian@smtresource.com>
To: pgsql-interfaces@postgresql.org
Subject: Linking to SQL server
Date: Tue, 10 Dec 2002 14:55:53 -0600
Message-ID: <FFEIKGEAKLLMIHKANBJAGEOECCAA.brian@smtresource.com> (raw)
Hello List,
I dont know if such a thing exists, and I have been looking in the archives
and havent found what Im looking for. Heres my question:
I am trying to find a way to link a table in a remote SQL Server database to
my pgsql database. Is there a way to do this without a middleman such as
Access? I am able to link the tables from both databases in access, but I
want to be able to control it all from the Linux machine. Any suggestions
on how to accomplish this? I am pretty sure there are ways because I have
seen some different threads on message boards, but no good instructions.
Basically, I will be happy if I can treat one of the tables on SQL server as
if it were in my PostgreSQL database. Any and all comments and suggestions
appreciated!
Brian Hoppe
Manager, E-Commerce Development & IT
SMTResource Group, LLC
http://www.smtresource.com/ <http://www.smtresource.com/;
http://www.smtspares.com/ <http://www.smtspares.com/;
Phone:(254)771-3508
Fax:(530)678-5220
2506 N. General Bruce Dr.
Temple, TX 76504
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: brian@smtresource.com
Subject: Re: Linking to SQL server
In-Reply-To: <FFEIKGEAKLLMIHKANBJAGEOECCAA.brian@smtresource.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox