> pk2@o2.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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---- Wiadomo¶æ Oryginalna ----
Od: Merlin Moncure <merlin.moncure@rcsonline.com>
Do: Richard Huxton <dev@archonet.com>
Kopia do: pgsql-odbc@postgresql.org, pk2@o2.pl
Data: Fri, 29 Apr 2005 09:28:49 -0400
Temat: RE: [ODBC] PostgreSQL - linked with MSSQL


> Another solution along the same vein is to use DTS (Data
transformation


it works a little bit. Probably I have the wrong OLE DB Provider.
It's unstable. How can I check the version of my OLE DB?


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings