I have an SDE 10.0 server and an SDE 10.1 server and I am trying to migrate the layers from 10.0 to 10.1. (On a side note the 10.0 server is running SQL Server 2005 and the 10.1 server is running SQL Server 2012.)
Some of the layers have archiving turned on and there seems to be no way to transfer the layer as well as all of the archival information. Is there a way to copy the layer and also its archive?
Alternately, can I just turn on archiving on the new server after transferring the layer, then copy the rows from the old server into the newly created archival table with a SQL tool (Import/Export Data)?