I am copying an SQL Server 2005 database in one server to a different, using the Database>Tasks>Copy Database wizard, and delay pills work great, aside from the timestamp column whose values aren't replicated.
It is possible to way to achieve the timestamp values be maintained on database copy?
Is it feasible to work with a backup after which restore it towards the server rather? May well be more trouble than it's worth in some instances, however it labored for me personally several time.
Database backup restore will probably work, but the best way I have used is SQL Data Compare: http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Makes patching data and schema changes (through the SQL Compare product) very easy...