Resolved sql / dw updates
- How-to
- Andrew Davis
- PowerBuilder
- Friday, 10 September 2021 03:35 PM UTC
Hi,
I have 3 databases that have a table that is the same structure
for example - customers which has fields
account
name
type
info
other
One is the master database by that i mean that it contains all the records
the other 2 have a subset and details are changed by the user ( i can not use a replication database in this case)
Is there an efficient way of updating / inserting the records into main database from the data in the 2 other database - using either datawindows/datastores or SQL statements or even stored procedures
I am using PB2019R2 and SQL Anywhere 16
regards and thanks in advance
Andrew
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.