On Wed, 2007-08-22 at 20:41 +0100, Richard Huxton wrote:
> Murali Maddali wrote:
> > This is what I am doing, I am reading the data from SQL Server 2005 and
> > dumping to out to Postgresql 8.2 database.
My 2 cents.. I'm doing roughly the same thing, but I'm using perl and
DBI to do it.
> Fastest
Joshua D. Drake wrote:
I have added transaction to my code and it took about 2 and half hours to
process around 48,000 records. Again all this time is taken by update method
on the adapter.
I don't know Perl to setup the database link to SQL Server 2005 and also I
don't have permission to write
At 01:30 AM 8/24/2007, Murali Maddali wrote:
options like a different driver I can use or through stored procedures. I
have to compare each column in each row before doing the update.
Do you have to compare with all rows, or just one? Can your
comparison make use of an index?
Link.
--
ssage-
> From: Richard Huxton [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 22, 2007 2:41 PM
> To: Murali Maddali
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Adapter update.
>
> Murali Maddali wrote:
>> This is what I am doing
--Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 22, 2007 2:41 PM
To: Murali Maddali
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Adapter update.
Murali Maddali wrote:
> This is what I am doing, I am reading the data from SQL Server 2005
>
Hello Group,
I have asked this question already on the NpgSql forum, but didn't get a
response so far. Sorry for cross posting, but want to check if any one had
any suggestions for my problem.
I am trying to do my updates through NpgsqlDataAdapter (I also tried with
Odbc driver with no luck) by
Murali Maddali wrote:
This is what I am doing, I am reading the data from SQL Server 2005 and
dumping to out to Postgresql 8.2 database.
while (r.Read())
_save(r, srcTblSchema, destTbl, destConn);
r.Close();
Hello Group,
I have asked this question already on the NpgSql forum, but didn't get a
response so far. Sorry for cross posting, but want to check if any one had
any suggestions for my problem.
I am trying to do my updates through NpgsqlDataAdapter (I also tried with
Odbc driver with no luck) by
