Is there any experience with SQL Server 2005 replication?
I want to do replication via Internet without implement VPN or physical
connection to SQL Server.
I think that this is imposible with SQL Server 2000 but watch a presentation
on TECHED which
says that this is possible with SQL Server 2005 ?
Grigoris,
I have set this up in a test environment and you're correct - using SQL
2005, it is now possible to use merge replication over HTTPS. Although you
need to be comfortable issuing certificates, maintaining virtual directories
etc, the guidelines in BOL are quite thorough and helpful. There is a
mistake in some documentation, and HTTP is not supported, so you have to
deal with certificates at some stage. Have a look at BOL for the full info,
and if you have any questions, probably the best place for the moment is the
beta newsgroups:
http://communities.microsoft.com/new...2005&slcid=us.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||I see. Well they (Microsoft) keep to do things complicated.
I mean you need IIS, sertificates, http and ftp not supported and so on...
Well this is step forward but..
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:eUAEsp0ZFHA.3280@.TK2MSFTNGP09.phx.gbl...
> Grigoris,
> I have set this up in a test environment and you're correct - using SQL
> 2005, it is now possible to use merge replication over HTTPS. Although you
> need to be comfortable issuing certificates, maintaining virtual
> directories etc, the guidelines in BOL are quite thorough and helpful.
> There is a mistake in some documentation, and HTTP is not supported, so
> you have to deal with certificates at some stage. Have a look at BOL for
> the full info, and if you have any questions, probably the best place for
> the moment is the beta newsgroups:
> http://communities.microsoft.com/new...2005&slcid=us.
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
Thursday, February 16, 2012
2005 Internet Replication
Labels:
database,
experience,
implement,
internet,
microsoft,
mysql,
oracle,
physicalconnection,
replication,
replicationi,
server,
sql,
via,
vpn
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment