Archiving

[itmagr]

What's the easiest way to move records from one table to another, both tables being identical ?

 

[lsdev]

Can you not just create a data table with a fill query based on that of the other table

 

[cjard]

What's the easiest way to move records from one table to another, both tables being identical ?

in oracle:
InSERT INTO dest SELECT * FROM src

in sqlserver:
SELECT * INTO dest FROM src


Next time you ask a question, please at least say what DB youre using?