replication over HTTPS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MC - 30 Jan 2006 08:31 GMT

I'm not certain if synch over the https is possible for transactional
replication? I did see the setup for merge, but there is no mention of
transactional. Now, is it possible or not? If not, why not?

Second, initialization (access to snapshot) over https? Possible or not?

MC

Reply to this Message

Hilary Cotter - 30 Jan 2006 12:06 GMT

Its possible with transactional replication - merge only. This feature is
only supported in SQL 2005.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I'm not certain if synch over the https is possible for transactional
> replication? I did see the setup for merge, but there is no mention of
[quoted text clipped - 3 lines]
>
> MC

Reply to this Message

MC - 30 Jan 2006 12:32 GMT

Yes, I realise that. Do you know why web (https) replication isnt possible
for transacional? And what about initialization, did you try doing it over
https?

MC

> Its possible with transactional replication - merge only. This feature is
> only supported in SQL 2005.
[quoted text clipped - 6 lines]
>>
>> MC

Reply to this Message

Hilary Cotter - 30 Jan 2006 13:36 GMT

I can only speculate. Transactional replication is intended for server to
server replication. Merge is intended for server to client. With merge
replication many more clients are replicating over the internet as opposed
to with transactional, and there needed to be a secure way of doing this.
https was selected as this port is open for inbound traffic on most
firewalls, and it is secure. Note that the web based synchronization method
was available before in SQL 2000 CE only it was http - so the technology is
well tested.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Yes, I realise that. Do you know why web (https) replication isnt possible
> for transacional? And what about initialization, did you try doing it over
[quoted text clipped - 12 lines]
>>>
>>> MC

Reply to this Message

Michael Hotek - 31 Jan 2006 15:29 GMT

It isn't possible, because it was never on the feature set. I know of lots
of people who requested this capability for merge, but none that wanted it
for transactional. One of the main reasons is that you are using an
inherently disconnected synchronization mechanism which fits in with the way
merge is run in almost all implementations, but is not the way transactional
is run. If you need the fature added to the transactional engine, you would
have to make a feature request.

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

> Yes, I realise that. Do you know why web (https) replication isnt possible
> for transacional? And what about initialization, did you try doing it over
[quoted text clipped - 12 lines]
>>>
>>> MC

Reply to this Message