Re: Migrating from MS SQL server

From: Andreas Tille <tillea(at)rki(dot)de>
To: Alex Bolenok <abolen(at)chat(dot)ru>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Migrating from MS SQL server
Date: 2000-08-10 07:06:14
Message-ID: Pine.LNX.4.21.0008100858570.13485-100000@wr-linux02.rki.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 18 Jul 2000, Alex Bolenok wrote:

> If you fail to set up an ODBC Subscriber, you may still try to set up an OLE
> DB Subsriber. First create a linked server (use OLE DB for ODBC) and insert
> either DSN or provider string into the corresponding field. Then if you
> select this linked server in the Enterprise Manager, you will see the tables
> that reside in the database you selected. It means that the linked server is
> set up properly. Then you should create a new OLE DB Subscriber and when
> asked select the linked server you have created. It must work too.
Back from holidays I did a further try to cope with your suggestion.
I really didn't managed to install the ODBC Subscriber for the
replication mechanism. Fortunately I managed to create a linked server
and finally I could see the tables of the PostgreSQL database.

Unfortunately my stupid German documentation dosn't give me any hint
how to create a OLE DB subscriber. (Does anybody know if I could
get a English one from MS once bought a German for free? - I suppose
not.) Could anybody tell me which damn menu I have to pull to get
such a beast installed. It's a shame to ask such questions here but
I really get upset yesterday when trying to fiddle around with this
beast :-( - sorry.

Kind regards

Andreas.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Guryanow 2000-08-10 11:38:47 problem with plpgsql function
Previous Message Joshua Adam Ginsberg 2000-08-10 06:33:30 PSQL woes