If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?If both server is in different geographical area or on a WAN, you will face a big threat from anyone in the world who wrote a simple program to guess your user "sa" password or any user account. To post that on a WAN, its preferable to go through a firewall.
There are 2 options:-
1) get a 1gigabit network adapter card and a switch that support 1GB.
2) make use of Client Utility Connection on both SQL server. Configured according to your Server Name with static IP address and specify the port that is use by both server. This will tell the replication agents to call the static ip.
Originally posted by sdonovan
If we had two SQL 2000 servers each with 2 NIC's. For each server one network card was pointing to an internal network 172.16.x.xxx we use for production. The other NIC (say its 198.16.x.xxx) we wanted to use just for replication purposes between the two servers in an attempt to lighten the network traffic on the 172 network. My question is, can you set up 2 SQL servers to replicate between themselves on a specific IP or Named Pipe?
Showing posts with label specific. Show all posts
Showing posts with label specific. Show all posts
Friday, March 30, 2012
Friday, March 9, 2012
Replication of specific records
How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad Tariq
No, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegr oups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad Tariq
No, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegr oups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
Labels:
clear,
database,
iwant,
microsoft,
mysql,
oracle,
parameterized,
publisher,
records,
replication,
server,
specific,
sql,
synchronization,
withsubscriber
Replication of specific records
How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
--
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
--
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
Labels:
clear,
database,
microsoft,
mysql,
oracle,
parameterized,
publisher,
records,
replication,
server,
specific,
sql,
subscriber,
synchronization
Replication of specific records
How replication can be parameterized, let me clear what actually I
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
want. From publisher side I want specific records synchronization with
subscriber by passing parameter against that parameter publisher will
fetch the records and replicate that records to subscriber. Is it
possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
me how is it possible, it will be appreciated, thanks in advance
regards
Shahzad TariqNo, you can't dynamically issue parameters against teh replication engine to
control what is synchronized. You can create filters on a publication such
that only a subset of the data is replicated between publisher and
subscriber.
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.
"Shahzad Tariq" <stariq@.gmail.com> wrote in message
news:1140447849.852129.291820@.g47g2000cwa.googlegroups.com...
> How replication can be parameterized, let me clear what actually I
> want. From publisher side I want specific records synchronization with
> subscriber by passing parameter against that parameter publisher will
> fetch the records and replicate that records to subscriber. Is it
> possible in SQL Server 2000 or SQL Server 2005. If yes then please tell
> me how is it possible, it will be appreciated, thanks in advance
> regards
> Shahzad Tariq
>|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq|||Thanks Michael, it means if I want to transfer specific records from
one database to another by passing parameters I have to write my owner
scripts for that purpose I have to handle transactions as well in those
scripts so that in case any failure it rollback everything. So far I
have already written such kind of script for said purpose,anyway thanks
for your response.
Shahzad Tariq
Labels:
clear,
database,
iwant,
microsoft,
mysql,
oracle,
parameterized,
publisher,
records,
replication,
server,
specific,
sql,
synchronization,
withsubscriber
Subscribe to:
Posts (Atom)