yea, I agree varchar as PK is not exactly not notch, but it's how they made this. Making a conversion from this system and want to be able to resume the etl operation if something breaks down. So basically something like this SELECT * FROM TABLE ORDER BY pk_varchar_field ,
and resuming would be something like SELECT * FROM TABLE WHERE pk_varchar_field > 'stored_checkpoint_value' ORDER BY pk_varchar_field
is it even possible to use '>' operator on varchar field?