Replication between sqlserver2000 and postgresql

hi all,
i need to establish replication betwen postgresql and sqlserver2000 .is any one allready did this type of replication.
is it possible to establish replication between sqlserver2000 database and any linkedserver.for example i linked the postgresqlsql server with sqlserver2000 through odbc.now i am able to view the data .can i establish replication between these servers.pls
help.
thanks®ards
reddy
I was unable to do this.
If you do have an ODBC connection, go to Tools, Replication, configure publishers, distributors, and subscribers, and then on the subscriber tab, click new, select ODBC (in the what type of Subscriber do you want to enable dialog?) and select your ODBC da
tasource. Enter the login information and the password (twice).
You should be able to go from there
You could also try to enable it as a linked server, by selecting OLE DB (in the what type of Subscriber do you want to enable dialog?) and then picking the name of your linked server and enter the account and password (twice).
I was unable to get this to work as I don't think the ODBC driver (are you using the OpenLink lite one, or the one from PostGres), is ODBC level 1 compliant.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"reddy" wrote:

> hi all,
> i need to establish replication betwen postgresql and sqlserver2000 .is any one allready did this type of replication.
> is it possible to establish replication between sqlserver2000 database and any linkedserver.for example i linked the postgresqlsql server with sqlserver2000 through odbc.now i am able to view the data .can i establish replication between these servers.p
ls help.
> thanks?ards
> reddy
>
|||hillary,
thank you very much for ur help.
i am using the openlinklite odbc driver to establish as a linked server.
i will try ur suggestions.
if u succeed please reply
thanks
reddy
|||HILLARY,
i tried ur option.i am unable to register postgresql as a subscriber.is any thirdparty tool is there .
please help
thanks
reddy
|||I was unable to get it to work. I was hoping perhaps you could get it
working, but I believe the problem is the odbc driver is not ODBC level
1conformance, or does not support long table names.
Can you run an odbc trace and post it here, also can you download this tool
and check the odbc conformance level.
http://support.microsoft.com/default.aspx?scid=kb;[LN];279882
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"reddy" <reddy@.discussions.microsoft.com> wrote in message
news:AC85CA82-4EC7-4E53-9791-83579AB85802@.microsoft.com...
> HILLARY,
> i tried ur option.i am unable to register postgresql as a subscriber.is
any thirdparty tool is there .
> please help
> thanks
> reddy
>