I'm curently working on a project where I need to transfer data (with some minor transformations) from one database to another. Everything was going just fine when I hit my first Timestamp column...
It seems SQL Server doesn't want me to use explicit values for this type of column and it, instead, wants to generate its own.
If there a way, using T-SQL, I can get this data from one table to another?
Note: The name timestamp is deprecated, the new (and more accurate) name is rowversion.
Two answers:
No: SQL Server columns of type rowversion are always generated and set by the database server.
Yes: If you use a different datatype in the target table. The values read from a rowversion column can be stored in a varbinary column. So you could create a varbinary column in the new table to hold the values from the old table. Of course, going forward this varbinary column would not get updated automatically like a rowversion column would.