How can I synchronize tables?

[gene.ellis@gmail.com]

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!

[David Gugick]

Re: How can I synchronize tables?

gene.ellis@gmai l.com wrote:[color=blue]
> 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![/color]

What does "synchroniz e" 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

https://www.imceda.com

https://www.quest.com

[David Portas]

Re: How can I synchronize tables?

An UPDATE followed by an INSERT is probably what you want.

--
David Portas
SQL Server MVP
--

<gene.ellis@gma il.com> wrote in message
news:1123544076 .734210.85550@g 49g2000cwa.goog legroups.com...[color=blue]
> 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!
>[/color]

[Neil MacMurchy]

Re: How can I synchronize tables?

did you hear gene.ellis@gmai l.com say in news:1123544076 .734210.85550
@g49g2000cwa.go oglegroups.com:
[color=blue]
> 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!
>[/color]

have a look at red-gate software's SQL tools or something similar (there
is an SDK for the redgate stuff) or setup replication to another database
that would happen automatically.

--
Neil MacMurchy

http://spaces.msn.com/members/neilmacmurchy

http://spaces.msn.com/members/mctblogs

[NC]

Re: How can I synchronize tables?

gene.ellis@gmai l.com wrote:[color=blue]
>
> 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.[/color]

Why does it have to be from time to time? What's preventing you
from updating both tables simultaneously?

Cheers,
NC