I have two database servers where the logins have been transferred so they both have the same sid values.

This means that I can simply do an automated BACKUP and RESTORE and know that the database will work on both machines.

In your case, you simply need to add a script to TRUNCATE all tables after performing your RESTORE.