I'm trying to create replication on an Great Plains Dynamics database. It's about 100 GB, however, there are thousands of Stored Procedures, hundreds of tables, views and UDFs. Using the New Publication Wizard, it locks up for about 15 minutes on the "Articles"
page and when it does resume, takes a couple hours to create the publication. If I have it generate a script to create the publication, the script files is 27 megabytes large and has 230,000 lines, mostly just sp_addarticle statements.
Trying to create the subscription on a second server runs for about 10 hours and still never finishes. By that time, my nightly window has closed, so I have to stop it. And it hasn't even started inserting the BCP files. The MDF files are the same size as
when they're first created.
I think restoring from a BAK file on the subscriber (rather than a snapshot) is the way to go. However, my question is, is it possible to create the initial publication without specifying each individual article it has to add.
The subscribing server will serve as both a disaster recovery and a SSRS database, to get the report queries off our production server. Because of the disaster recovery need, I must attach all tables, all prcos, all views, etc.
Can't I just say something like ADD ALL ARTICLES?
View Complete Post