Paradox Community

Items in pnews.paradox-client_server

Subject:Best way to Add from Paradox Table to AWS Postgres Table
Date:Sun, 10 May 2020 17:38:25 +1000
From:Robert MacMillan <macfam@bigpond.net.au>
Newsgroups:pnews.paradox-client_server
So adding works just fine using a standard add. Just like in Liz's 
question from years ago. It is pretty slow though so I am rapidly going 
to run into performance problems.

I am wondering whether a scan reading each record into a dynamic array 
then inserting a blank record at the other end and then copyfromarray 
will work better and faster?

Also if one uses this method does it also mean that as long as the field 
names are identical then the order of fields in the two tables can be 
different?

And supplementary question. Does that also mean that as long as every 
field is in the AWS table then that table could contain additional 
fields that the rows will fill in correctly and fields that are not in 
the Paradox Table but are in the AWS Table will be left blank? I presume 
if the AWS Postgresql Table has fields that are not allowed to be null 
that it wont work?


Copyright © 2004 thedbcommunity.com