• Are you replicating 140,000 tables, or is that split among SPs, views etc?

    You can stage it in several publications so that it is less of a strain to initialize. Also, you don't have to initialize through a snapshot.

    Also, I would not replicate non table objects unless it was truly required.

    Converting oxygen into carbon dioxide, since 1955.