What are the challenges you face when working across database platforms? Take the survey

Deployment Script Insert Statements question


I'm working with the 14 day trial and have a question. Is it possible to have the insert statements created without the primary key value hard coded, so the the target will generate it's own value on insert?

Both source and target tables have primary key columns using identity feature.

Brian Peasey


  • Options
    Hey Brian,

    Thanks for posting!
    That is not currently an option (mainly because it does the comparison based on the identity values), but that does does sound like something we could add in the future. I recommend you post your idea in our UserVoice forum here

    Do let me know if you have any other questions or issues!

    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
Sign In or Register to comment.