Home » RADICORE » How To » Batch Script connecting two databases in an Extract Tranform Load (ETL) Design Pattern(Do you have any advice about how to structure a program that will be moving data between pgsql and sqlsrv databases?)
AJM Messages: 2347 Registered: April 2006 Location: Surrey, UK
Senior Member
The title of this thread suggests that you are copying from one database to another, yet your sample code shows that you are reading and writing to the same table 'sids'. If the update is not working you need to step through with your debugger to see what values are actually being passed to the update method as what is being received may be different from what you think you are sending. If none of the table's columns have actually been changed then nothing will be updated.
Radicore Forum
Search
Help
Members
Register
Login
Home
