• Don't know enough to truly answer the question, but..

    IF the entire database (all objects) is identical in structure, and IF all the tables are fully published, then you could:

    1) kick everyone off

    2) remove replication

    3)

    either

    a) backup both databases

    restore the databases as the other (i.e. swap names and locations)

    setup replication as it was

    or

    b) point all updating applications/users at old subscriber

    point read-only stuff at old publisher

    setup reversed replication, i.e. old subscriber is now publisher

    4) let everyone on again


    Have Fun!
    Ronzo