DTS or Snapshot replication

[kodaksmile]

Good afternoon all,

I am faced with a challenge of moving 60 gigs of data (tables, indexes, stored procs) from one database to another nightly. This is not the entire database so I cannot do a restore. I need to copy the data at night and then let users update it during the dayand replace it the following night with production data. My question is if I use DTS it may be slow but, will snapshot replication be any faster? Since this will be in a changing environment (table structures, indexes etc) does that impact the choice? I have used DTS in the past but, not for large amounts of data like this. I will need it to complete within a couple of hours.

Thanks in advance

 

[dbomrrsm]

would it be quicker to do a restore and then delete ?

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[kodaksmile]

No as the database is 420 gigs total and I do not have that much space available. Also this is in MSSQL7.