Snapshot Replication

Question

Hello Folks,

There is any way to do the merge replication by sending the snapshot generated for the replication from publisher[SQL Server 2012 EP] to the subscriber [SQL server Express] by mail   and apply the snapshot at the subscriber by a sql server job.

Answer 1

I do not understand your question. You can not create snapshot with mail.

Why do you want MAIL here? Simple answer is If you dont have connectivity between publisher and subscriber, you can not have Replication at all. 

Answer 2

Yes, this is possible. After the snapshot has arrived on the subcriber you can deploy if via the altsnapshot folder or dynamicsnapshot location settings parameter of replmerg.exe

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 3

Yes, this is possible. After the snapshot has arrived on the subcriber you can deploy if via the altsnapshot folder or dynamicsnapshot location settings parameter of replmerg.exe

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Hello Hilary,

    Actually I have an impression that it needs to have a connectivity between publisher and subscriber to create a snapshot. But your reply looks like we do not need a connectivity. Thanks for sharing the same.

Could you please share any link with me or any of you blogs that illustrates the same. 

Answer 4

You need connectivity to apply the snapshot. The subscriber has to get reference data from the publisher but can apply the snapshot locally from a folder. The snapshot data can be sent to the subscriber by a multitude of means, ftp, file copy or email.

But the subscriber does need to connect to the publisher - it can't be completely isolated from the publisher.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 5

You need connectivity to apply the snapshot. The subscriber has to get reference data from the publisher but can apply the snapshot locally from a folder. The snapshot data can be sent to the subscriber by a multitude of means, ftp, file copy or email.

But the subscriber does need to connect to the publisher - it can't be completely isolated from the publisher.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Ok, Now am clear on your comment. Thanks Hilary.

Answer 6

Thanks Latheesh! for attending my query.My requirement is like we need to replicate some data change's from central server to client on periodic basis.

Client is with SQL express and only facilitated with satellite connection with  POP3...Thats why I am asking whether I can send the snapshot generated from publisher as packet by mail and apply manually or by a scheduled job to subscriber.

Answer 7

This isn't really possible using merge replication. You need to implement some form of change tracking and then package up those changes and mail them to the subscriber. Then you will need some code to download the data from your pop3 mailbox and apply it on the subscriber.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941