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
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 |