Re: Linked Server (Comment) - Mailing list pgsql-odbc
From | Jeff Crumbley |
---|---|
Subject | Re: Linked Server (Comment) |
Date | |
Msg-id | 58748158EFB67344819B48564FCAD4A808119BD9@exchange2.iilogistics.com Whole thread Raw |
List | pgsql-odbc |
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. 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] 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 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 programmatically. I suggest using PgSqlLoader and PgSqlScript components. You can download a Trial version of PostgreSQLDirect .NET from www.crlab.com Best regards, Alexey Mandrychenko ----- Original Message ----- From: "Jeff Crumbley" <jeffc@iilogistics.com> To: "Alexey Mandrychenko" <AlexeyMan@crlab.com> 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 linked server from 64 bit SQL Server to Postgres. A linked server is an ability in SQL Server for queries to be run directly from the Query Manger or a Stored Procedure within SQL Server but run against a data source other than SQL Server. Generally this is done by establishing an ODBC connection and creating the linked server within SQL Server which would utilize the ODBC connection. I currently have this configured in a 32 bit environment which works great but now I need to come up with a solution for the 64 bit environment as the 32 bit ODBC driver I am using is not recognized by the 64 bit version of SQL Server. Any information you can provide would be greatly 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 ----- From: "Jeff Crumbley" <jeffc@iilogistics.com> To: <info@crlab.com> 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
pgsql-odbc by date: