Replication across the internet

Hi,
I want to replicate my data with a sql server in internet(via dial-up
connection).
Do I necessarily need to use FTP for transferring the initial snapshots or
it is an alternate solution?
I saw this in article number '321822' in Microsoft's site, the second
example in this article mentions:
Example 2: The Subscriber Does Not Have the Schema and Data, and the Initial
Subscription from the Publisher Is Required.
This example requires you to configure the FTP service at the Publisher, and
then configure the Subscriber to download the initial snapshot from the FTP
site. For more information, see the following topics in SQL Server Books
Online...
Thanks in advance,
Amin
you don't need to. Somehow you need to get the schema and data to the
subscriber. You can't use a UNC, so you have to use FTP, or get them there
via mail, courier or some other system.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"Amin Sobati" <amins@.morva.net> wrote in message
news:OddhXyBXEHA.3640@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I want to replicate my data with a sql server in internet(via dial-up
> connection).
> Do I necessarily need to use FTP for transferring the initial snapshots or
> it is an alternate solution?
> I saw this in article number '321822' in Microsoft's site, the second
> example in this article mentions:
> --
> Example 2: The Subscriber Does Not Have the Schema and Data, and the
Initial
> Subscription from the Publisher Is Required.
> This example requires you to configure the FTP service at the Publisher,
and
> then configure the Subscriber to download the initial snapshot from the
FTP
> site. For more information, see the following topics in SQL Server Books
> Online...
> --
> Thanks in advance,
> Amin
>
|||Hilary,
If I'm creating a push subscription, and my publisher is distributor too,
then I suppose the snapshot on my local hard drive can be used by merge
agent, is it correct?
Thanks,
Amin
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:OQ#8NYLXEHA.2844@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> you don't need to. Somehow you need to get the schema and data to the
> subscriber. You can't use a UNC, so you have to use FTP, or get them there
> via mail, courier or some other system.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "Amin Sobati" <amins@.morva.net> wrote in message
> news:OddhXyBXEHA.3640@.TK2MSFTNGP11.phx.gbl...
or
> Initial
> and
> FTP
>
|||The distributor doesn't really factor into merge replication other than
being a repository where historical information is held.
You should be using a PULL subscription when you are replicating over the
internet. If you open the NetBIOS (IIRC) necessary for a push subscription
you are exposing your self to hackers.
"Amin Sobati" <amins@.morva.net> wrote in message
news:O00$21NXEHA.3512@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hilary,
> If I'm creating a push subscription, and my publisher is distributor too,
> then I suppose the snapshot on my local hard drive can be used by merge
> agent, is it correct?
> Thanks,
> Amin
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:OQ#8NYLXEHA.2844@.TK2MSFTNGP11.phx.gbl...
there[vbcol=seagreen]
snapshots[vbcol=seagreen]
> or
Publisher,[vbcol=seagreen]
the[vbcol=seagreen]
Books
>
|||Hilary,
I'm only the owner of the database at subscriber, and there's some errors
while trying to create pull subscription. Our sql server host(subscriber)
has added my publisher name(computer name) as a remote server and mapped all
of our logins(local) to the login which was created at their sql server. But
still there're some error indicating the loss of permissions.
What's the best solution?
Thanks,
Amin
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:#7ZT5bQXEHA.2364@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> The distributor doesn't really factor into merge replication other than
> being a repository where historical information is held.
> You should be using a PULL subscription when you are replicating over the
> internet. If you open the NetBIOS (IIRC) necessary for a push subscription
> you are exposing your self to hackers.
> "Amin Sobati" <amins@.morva.net> wrote in message
> news:O00$21NXEHA.3512@.TK2MSFTNGP12.phx.gbl...
too,[vbcol=seagreen]
> there
dial-up[vbcol=seagreen]
> snapshots
second
> Publisher,
> the
> Books
>
|||Hilary,
I'm only the owner of the database at subscriber, and there's some errors
while trying to create pull subscription. Our sql server host(subscriber)
has added my publisher name(computer name) as a remote server and mapped all
of our logins(local) to the login which was created at their sql server. But
still there're some error indicating the loss of permissions.
What's the best solution?
Thanks,
Amin
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:#7ZT5bQXEHA.2364@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> The distributor doesn't really factor into merge replication other than
> being a repository where historical information is held.
> You should be using a PULL subscription when you are replicating over the
> internet. If you open the NetBIOS (IIRC) necessary for a push subscription
> you are exposing your self to hackers.
> "Amin Sobati" <amins@.morva.net> wrote in message
> news:O00$21NXEHA.3512@.TK2MSFTNGP12.phx.gbl...
too,[vbcol=seagreen]
> there
dial-up[vbcol=seagreen]
> snapshots
second
> Publisher,
> the
> Books
>

Replication across domains ...

I need information on setting up replication across domains. What kind of
gotchas there are, what kind of trust relationships need to exist. All the
gory details.
Any links to resources would be most helpful.
Thanks,
Bob Castleman
DBA Poseur
use passthrough authentication, i.e. same account names and passwords and it
will work fine.
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
"Bob Castleman" <nomail@.here> wrote in message
news:%23kk9KqOqFHA.3136@.TK2MSFTNGP11.phx.gbl...
>I need information on setting up replication across domains. What kind of
>gotchas there are, what kind of trust relationships need to exist. All the
>gory details.
> Any links to resources would be most helpful.
> Thanks,
> Bob Castleman
> DBA Poseur
>

Replication across different networks

Hi all,
I would be grateful if you all could help.
I have one server acting as publisher and distributor in one data center
and the other one center acting as subscriber in another data center.
I would like to perform replication between these two computers.
In order to perform replication, these two computers must be in the same
domain.
Are there any feasible solutions that i can perform replication betwen
these two computers across different networks?
Thx so much!!!
On 2004-12-06, Eric <Eric@.discussions.microsoft.com> wrote:
> Hi all,
> I would be grateful if you all could help.
> I have one server acting as publisher and distributor in one data center
> and the other one center acting as subscriber in another data center.
> I would like to perform replication between these two computers.
> In order to perform replication, these two computers must be in the same
> domain.
> Are there any feasible solutions that i can perform replication betwen
> these two computers across different networks?
If it's all TCP/IP, you don't have a problem. You don't have to have your
servers in same domain. I'm even doing replication over internet trough SSH
tunneling, via two unix machines, it works perfectly fine.
What you need to do is make sure you have TCP/IP connection to the remote
machine. You could test this by issuing this from command prompt:
telnet <remote.machine.ip> 1043
If you get connected (the screen goes blank), it means you're ok. If you get
'connection refused', 'connection closed by remote host', 'no route to
host', or similair, or you just kepp hanging at 'connecting...', it means
you don't have connection.
Once you established connection you should add the clients server ip to the
SQL Client Network utility with apropriate alias. Then you use that alias in
EM to establish replication between these two servers. Replication scripts
will use IP address stored in the client network utility when translating
the alias name you specified.
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr