We are moving data from the old server to the new server.
@iddpanganiban you cannot add identity columns to existing tables. Only way to add them is recreate the table with identity column, copy the data to new table and drop old table.
Answers
@iddpanganiban you cannot add identity columns to existing tables. Only way to add them is recreate the table with identity column, copy the data to new table and drop old table.