Thanks Lowell for your Quick response ..

do all 520 tables have the DateCreated column with a default of getdate(), so that the tables can be queried individually to archive off the data as desired?

- Yes all the tables have "DateCreated" column

if not, you could add the column today, but if you have a backup from 6 months ago, you could restore that as a different database, and determine what is "new" in the current production database, to help define what is older.

- Requirement is that the data older than 6 months should be moved to another server with the same database name. For better performance this requirement was raised and this must be finished by today,...

why is it urgent? are you running out of disk space?

- Its a requirement now from my Administration and our request tooo, to improve the performance.

what happens if a parent record is 6 months old, but a child record related to the parent is 3 months old? maybe you mean just certain tables should be archived?

- Yes, i mean that the data older than 6 months should be moved out from Live DB and should be deleted once the transfer of data is succeeded. If the child record is required then we will pull the data from the archived DB. That will not be a problem...

If wrong, Suggest me !!!

Any scripts or the tools please...!!