Duplicating tables as a backup

[DGEE]

Greetings All. We have two exact tables; one receives live SQL data via ODBC the other we would like to use as a backup table of that same data. As records are deleted from the SQL db, we need a way to copy those records exactly field by field to the local table.

Best suggestions on how to do this? This is a great resource...

Thank You.

-DGEE

Edited June 16, 2008 by Guest

[LLX]

when the SQL is exceuting the DeleteFrom can't you just excecute a AddTo or Update on the local db?

[DGEE]

Thanks for your reply.

I am afraid I don't know too much about modifying the SQL database so our preference would be to "Update" on the local table independent of the SQL database.

I was hoping for an easy 'copy all' script that would just mirror the SQL table and keep all those records local. Does that make any sense?

Thanks for any other suggestions.

-DG