• You could (protect your identity by 😉

    1. Script the database

    2. Run the create table part only at the destination

    3. Use Import wizard to transfer the data, enable identity insert and filter where needed

    4. Run the constraint part of the database script

    or

    1. Copy database

    2. Script the constraints and drop them

    3. Clean the data

    4. Re-Create the constraints

    Hint, look up IDENTITY_INSERT

    😎