From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Access postgresql data base from .net |
Date: | 2010-11-06 00:40:26 |
Message-ID: | 4CD4A3FA.5040805@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/05/10 2:40 PM, mike stanton wrote:
> Dann, perhaps the a better question would be.....if we use, for
> example, npgsql, we'd have to adapt code and use the tools own calls.
> And that means rewriting. Is this true?.
>
npgsql implements oledb, I thought, which hooks right up to the .NET
database glue? That should just hook up to your existing SQL code. If
your SQL code follows the standards, it should work with little or no
tweaking.
however....
if you are using any Microsoft SQL Server specific features, you'll need
to rewrite those parts to switch to /anything/ else. Any transact*sql
procedures will need rewriting into pl/pgsql.
SQL Server's ETL tool should be able to copy your schema and data into
postgres tables.
From | Date | Subject | |
---|---|---|---|
Next Message | Jacqui Caren-home | 2010-11-06 09:16:03 | Re: Re: Modfying source code to read tuples before and after UPDATE...how to? |
Previous Message | Francisco Figueiredo Jr. | 2010-11-06 00:05:36 | Re: Access postgresql data base from .net |