Paradox Community

Items in pnews.paradox-client_server

Subject:Re: Best way to Add from Paradox Table to AWS Postgres Table
Date:Sun, 10 May 2020 18:11:44 +1000
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-client_server
Every one of those is going to give you headaches. Why don't you just 
export Paradox data to a csv, and bulk add it into PostgrsSQL? You can 
create a Paradox script to do that.

On 10/05/2020 5:38 pm, Robert MacMillan wrote:
> 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