Re: PostgreSQL - linked with MSSQL

From: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>, <pk2(at)o2(dot)pl>
Subject: Re: PostgreSQL - linked with MSSQL
Date: 2005-04-29 13:28:49
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3415C26F1@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> pk2(at)o2(dot)pl wrote:
> > Generally I would like to have the same possibility to make an:
> > INSERT INTO [Postgres_server].mydatabase.user.mytable
> > (id, data1, data2, data3)
> > SELECT
> > id, data1, data2, data3
> > FROM [remote_mssql].remotedatabase.dbo.table2
>
> The quick solution (and the one I always use) is to setup ODBC for
> postgresql, then create an MS-Access database that links to both. Add
a
> bunch of queries/vba and you're done.

Another solution along the same vein is to use DTS (Data transformation
services) to manipulate the data. The nice thing about dts is it can
integrate right into the scheduler so you can 'publish' the data between
different data sources.

DTS is free with the desktop edition of sql server, :-).

Merlin

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message pk2 2005-04-29 15:08:59 Re: PostgreSQL - linked with MSSQL
Previous Message Richard Huxton 2005-04-29 10:49:43 Re: PostgreSQL - linked with MSSQL