Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : replication over HTTPS


MC
1/30/2006 12:00:00 AM
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

Hilary Cotter
1/30/2006 12:00:00 AM
Its possible with transactional replication - merge only. This feature is
only supported in SQL 2005.

--
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

[quoted text, click to view]

MC
1/30/2006 12:00:00 AM
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

[quoted text, click to view]

Hilary Cotter
1/30/2006 12:00:00 AM
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.

--
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

[quoted text, click to view]

Michael Hotek
1/31/2006 9:29:25 AM
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.

--
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.


[quoted text, click to view]

AddThis Social Bookmark Button