> oh no it's not a contact database, it's was a sample... it's a real estate property database all around the world ( http://www.arkadia.com/usa/ ) the database is not so big, but when we keep the archived record yes it's become very big !
>
> now how to easyly move one record from the main table to the archived table by storedprocedure and handle at the same time all foreign key ?

May I suggest you to use two databases? In operative database you can
have only small amount records while in archive database you'll have
full set of records (including operative). Actuality of archive database
can be maintained by a replicator.
Operative database can be used for OLTP while OLAP can be done in
archive database.

SY, SD.