Re: Linked Server (Comment)

Alexey,

Thanks for your inquiry. I am using SQL Server Administrator (SQL
Server 2005). The plan is to setup Stored Procedures that can be called
from PostgreSQL or SQL Server to make sure any processes used to
transfers data between systems stays consistent. When these processes
run it will most likely be copying and updating 1000s of records at a
time. With a Stored Procedure, the same procedure can be called whether
it is called from a Unix application, a Windows app, from inside of SQL
Server, or from inside a PostgreSQL function.

In my test environment I have everything working as described above. No
outside coding in .Net was done. I can call Functions and query
Postgres directly from SQL Server. In Postgres I can call Stored
Procesdure and query SQL Server 2005.

I basically just need a 64 bit driver for SQL Server 2005 that I can
call directly from within SQL Server 2005 Management Studio so I can
write stored procedures without having to create custom code every time
I need to change or transfer data. That scenario would.=20

It sounds like PostgreSQLSirect.Net would require me to custom code
something in .Net which would eliminate the ability for me to create
Stored Procedures which means I would have two or more pieces of custom
code to maintain and try to keep in sync between Unix and Windows. Not
a good solution.

Anything you or anyone else can provide would be appreciated.

Thanks,

Jeff

-----Original Message-----
From: Alexey Mandrychenko [mailto:AlexeyMan@crlab.com]=20
Sent: Monday, April 21, 2008 4:34 AM
To: Jeff Crumbley
Subject: Re: Linked Server (Comment)

Hello Jeff,

what MS SQL server administrative tool do you use?
Is it MS Management Studio or do you connect through Visual=20
Studio?
Please specify version and edition.
It's likely you can choose a data provider there,
i.e. instead of ODBC you might set PostgreSQLDirect .NET.

As alternative, you can do such data transmissions=20
programmatically.
I suggest using PgSqlLoader and PgSqlScript components.
You can download a Trial version of PostgreSQLDirect .NET=20
from
www.crlab.com

Best regards,
Alexey Mandrychenko
----- Original Message -----=20
From: "Jeff Crumbley"
To: "Alexey Mandrychenko"
Sent: Friday, April 18, 2008 11:08 PM
Subject: RE: Linked Server (Comment)


Alexey,

Thanks for your prompt response. My plan is to create a=20
linked server
from 64 bit SQL Server to Postgres. A linked server is an=20
ability in
SQL Server for queries to be run directly from the Query=20
Manger or a
Stored Procedure within SQL Server but run against a data=20
source other
than SQL Server. Generally this is done by establishing an=20
ODBC
connection and creating the linked server within SQL Server=20
which would
utilize the ODBC connection.

I currently have this configured in a 32 bit environment=20
which works
great but now I need to come up with a solution for the 64=20
bit
environment as the 32 bit ODBC driver I am using is not=20
recognized by
the 64 bit version of SQL Server.

Any information you can provide would be greatly=20
appreciated,

Thanks,

Jeff

-----Original Message-----
From: Alexey Mandrychenko [mailto:AlexeyMan@crlab.com]
Sent: Friday, April 18, 2008 8:59 AM
To: Jeff Crumbley
Subject: Re: Linked Server (Comment)

Hello,

it's not clear how you are going to implement such data
transmitting.
Are you going to write a special application or are you
going to use a tool?
Basically, we do not see any obstacles in using
PostgreSQLDirect .NET on 64-bit machines.

Best regards,
Alexey Mandrychenko
----- Original Message -----=20
From: "Jeff Crumbley"
To:
Sent: Friday, April 18, 2008 12:24 AM
Subject: Linked Server (Comment)


To whom it may concern:

I ran across your product as I was searching for a way to
Create a linked server from SQL Server 2005 (64 bit) to
Postgres. I have used the odbc driver provided on the
postgres site to accomplish this in a 32 bit environment,
however 64 bit SQL Server does not allow me to call a 32 bit
driver. Would your product happen to resolve this issue for
me or do you know another way to resolve this issue?

Thanks,

Jeff



__________ Information from ESET NOD32 Antivirus, version of
virus signature database 2938 (20080311) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com







--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc