Posted by David Gugick on 10/01/00 11:23

gene.ellis@gmail.com wrote:
> Using a web interface, I am placing text into a SQL database. From
> time to time, I would like to synchronize one of my other tables in
> the database with the table that I am inserting content into. What is
> the SQL command to synchronize these tables? I will be initiating this
> command through a web interface, so I cannot use enterprise manager.
> Thank you very much!

What does "synchronize" mean in your situation? Are you asking how to
make sure all the data from TableA is migrated to TableB? Do you want
the data in TableB completed replaced or do you want TableA data
integrated into whatever exists in TableB? What about rows in TableB
that don't exist in TableA? Do you need them synchronized back to
TableA?

Regarding your question about the "SQL Command", there really is none
specifically designed for data synchronization. You have to use
INSERT/UPDATE/and DELETE statements as needed to do this.

If you post your complete table DDL and explain your situation with a
little more detail, we might be able to provide a more detailed solution
for you.

--
David Gugick
Quest Software
www.imceda.com
www.quest.com

[Back to original message]