replication technique

Hello,
I read serveral articles about the mechanism of replication from a sql
server 2000 database on
desktop with an mobile device running windows mobile.
I want to remark my understanding fo the replication mechanism and wanted to
ask you if you
could give me feedback if I understand it in a correct way.
-----
1) First of all I create a publication - which is a collection of articles -
rows. It is
possible to define certain tables and rows for publication.
2) After the publication a windows ce-based application can call the methods
of the SQL Server
Ce Replication object to subscribe to the publication. When the mobile
application has executed
the subscription the initial snapshot of the published table is stored on
the mobile device and
so the database file is created on the device.
3) The subscription database on the device can then be updated by
synchronzing it with the desktop
database. For that the synchronisation is always intiated by the device. For
that the SQL Server CE
Client Agent extracts all modified rows from the subscription database put
these rows in a message
file and sends it over HTTP to the SQL Server CE Server Agent. The SQL
Server CE Server Agent
creates a new message file on the desktop where the IIS is running and
writes in that file the
modified rows which are sent by the SQL Server CE Client Agent.Then the SQL
Server CE Server Agent
initiates the SQL Server Reconciler process. The SQL Server Reconciler
Process loads the SQL Server CE
Replication Provider which reads the message file which was created by the
SQL Server CE Server Agent
and apply the changes to the publisher database. The SQL Server CE
Replication Provider informs the SQL Server
Reconciler about the changes which were made in the subscription
database.The SQL Server Reconciler
also solves conflicts if more than one subscriber or publisher updates the
same record.
On the other hand the SQL Server Reconciler informs the SQL Server CE
Replication Provider of
changes which occured at the publisher database. The SQL Server CE
Replication writes this
information - especially the modified rows - to an output message file.
After the Reconciler
process is completed the SQL Server CE Server Agent locates the the output
message file reads
the information and transfer it to the SQL Server CE Client Agent which
apply the changes from
the output message file to the subscription databse on the windows ce device.
-----
a) Are these steps correct or have I forgotten anything important or have I
understand something
wrong?
b) What I have to imagine behind the SQL Server CE Client Agent, the SQL
Server CE Server Agent,
SQL Server Reconciler and the SQL Server CE Replication Provider? What are
these terms exactly?
c) When I publish a database, especially tables in the enterprise manager
the tables get automatically
a row guid. What part plays these row guid's in my above mentioned
replication process?
d) The Replication Mechanism uses static and dynamic filtering. Is it right
that the dynamic filter
could not use on the application layer? - means that it is not possiblt to
replicate for example
the information according to the user which is currently logged in the
application? - I think it
is only possible to synchronize according to a certain device especially
certain host, is that right?
I know this is a extensive posting but I would appreciate it very much if
anybody find time to
answer me my questions. :-/
Regards.
patrick
answers inline
--
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
"pat" <pat@.discussions.microsoft.com> wrote in message
news:273513F0-8240-4E1A-9598-9ED04BC448CE@.microsoft.com...
> Hello,
> I read serveral articles about the mechanism of replication from a sql
> server 2000 database on
> desktop with an mobile device running windows mobile.
> I want to remark my understanding fo the replication mechanism and wanted
> to
> ask you if you
> could give me feedback if I understand it in a correct way.
> -----
> 1) First of all I create a publication - which is a collection of
> articles -
> rows. It is
> possible to define certain tables and rows for publication.
Yes, you will need to set up a merge publication. When you say rows for
publication you mean horizontal filtering.
> 2) After the publication a windows ce-based application can call the
> methods
> of the SQL Server
> Ce Replication object to subscribe to the publication. When the mobile
> application has executed
> the subscription the initial snapshot of the published table is stored on
> the mobile device and
> so the database file is created on the device.
Yes, you will code something using vb or vc embedded or the .Net compact
framework to pull a merge subscription. This will use a SQL CE database on
your PocketPC.
> 3) The subscription database on the device can then be updated by
> synchronzing it with the desktop
> database. For that the synchronisation is always intiated by the device.
> For
> that the SQL Server CE
> Client Agent extracts all modified rows from the subscription database put
> these rows in a message
> file and sends it over HTTP to the SQL Server CE Server Agent. The SQL
> Server CE Server Agent
> creates a new message file on the desktop where the IIS is running and
> writes in that file the
> modified rows which are sent by the SQL Server CE Client Agent.Then the
> SQL
> Server CE Server Agent
> initiates the SQL Server Reconciler process. The SQL Server Reconciler
> Process loads the SQL Server CE
> Replication Provider which reads the message file which was created by the
> SQL Server CE Server Agent
> and apply the changes to the publisher database. The SQL Server CE
> Replication Provider informs the SQL Server
> Reconciler about the changes which were made in the subscription
> database.The SQL Server Reconciler
> also solves conflicts if more than one subscriber or publisher updates the
> same record.
> On the other hand the SQL Server Reconciler informs the SQL Server CE
> Replication Provider of
> changes which occured at the publisher database. The SQL Server CE
> Replication writes this
> information - especially the modified rows - to an output message file.
> After the Reconciler
> process is completed the SQL Server CE Server Agent locates the the output
> message file reads
> the information and transfer it to the SQL Server CE Client Agent which
> apply the changes from
> the output message file to the subscription databse on the windows ce
> device.
>
This is basically it.
> -----
> a) Are these steps correct or have I forgotten anything important or have
> I
> understand something
> wrong?
that's basically it

> b) What I have to imagine behind the SQL Server CE Client Agent, the SQL
> Server CE Server Agent,
> SQL Server Reconciler and the SQL Server CE Replication Provider? What are
> these terms exactly?
> c) When I publish a database, especially tables in the enterprise manager
> the tables get automatically
> a row guid. What part plays these row guid's in my above mentioned
> replication process?
it uniquely identifys each row, so SQL Server can figure out which row has
changed or needs changing.

> d) The Replication Mechanism uses static and dynamic filtering. Is it
> right
> that the dynamic filter
> could not use on the application layer? - means that it is not possiblt to
> replicate for example
> the information according to the user which is currently logged in the
> application? - I think it
> is only possible to synchronize according to a certain device especially
> certain host, is that right?
>
No, you define your filter on the publication. I don't believe you can
filter your subscribers.

> I know this is a extensive posting but I would appreciate it very much if
> anybody find time to
> answer me my questions. :-/
> Regards.
> patrick
>
|||Hello,
Thank you very much for your reply but few things are still unclear:
1) Why do I need the row guid? - the changed rows are saved in a file and
are sent to the SQL Server CE Server Agent, so he knows which rows were
modified when he looks into the message file. Why does he need then a row
guid?
2) The SQL Server CE Client Agent, the SQL, Server CE Server Agent, SQL
Server Reconciler and the SQL Server CE Replication Provider - are these
processes or components or parts of the os? what I have to imagine behind
these terms?
3) Referring to dynamic filtering I thought it is possible to synchronize
after a certain host on the mobile device? - What can I then realize with
dynamic filterin?
(static filtering is when I define some rows or columns or tables which I
can then synchronize or?)
Hopefully you could answer me once more.
regards
patrick
3)
|||Hi,
Thank you very much for your reply but unfortunately few things are unclear:
1)Why do I need this row guid's, because the SQL Server CE Server Agent
reads the modified rows from the message file which is sent by the SQL
Server CE Client Agent and so the SQL Server CE Replication Provider knows
what rows he has to modify. So why do I neet this row guids?
2)Tthe SQL Server CE Client Agent, the SQL Server CE Server Agent, SQL
Server Reconciler and the SQL Server CE Replication Provider - what do I have
to imagene behind these terms? Are these processes or components or part of
the os or anyting else?
3)Referring to the filtering. So it is not possible to define a filter
according to a certain host on a mobile device? - The static filtering allows
to define some rows or columns or tables which can be modified, but then for
what is the dynamic filtering?
regards
patrick
|||hi,
is it possible to answer me the last time on my three posted questions?
regards
patrick
sql

replication SQLServer 2-way

We have 2 SQLServer-databases with the same table in it. In both databases the table can be updated by users.
Is is possible to replicate the updates in this table from the one database to the other and vice versa? We want to use transactional-replication.You can setup an updatable transactional replication. To do that, specify 'true' to the paramenter @.allow_sync_tran when you execute sp_addpublication. And @.update_mode = 'sync tran' when you execute sp_addsubscription.|||Just out of curiousity, why can't he use merge replication instead?
I'm still learning from this replication thing...is there any reasons for chosing transactional against merge for this purpose?|||My personal experience in both merge and updatable transactional is that merge is slower, and it take a lot more to setup and manage. You can treat updatable transactional just like the regular transactional replication with a couple of more parameters to setup. There are other minor reasons but the main thing is the simplicity and better performance of transactional replication.

Hope this helps.|||joejcheng,

We tried the solution you provided and it works fine now. Thank you for your information.

Replication says success, but tables not showing in EM?

Hello All,
I am trying to replicate data from a SQL Server (7.0) to another SQL
Server using a one-way immediate push subscription. After executing,
there are no errors in the Snapshot or Push agents, but two of the
tables are missing in the subscription database. Where did they go?
I can find the tables listed in the publication->articles tab and in
the snapshot logs on the publisher. The tables are also listed on the
subscriber database under 'Database Roles Properties' --> Permissions.
Thank You For Your Time And Help,
Nate
Hi Nate,
You may want to check whether subscriptions for the two missing tables were
really created by calling sp_helpsubscription at the publisher. If not,
manually add them by calling sp_addsubscriptions with explicit article names
and rerun snapshot + distribution agents.
-Raymond
"Nate" <nathandeneau@.braintrade.biz> wrote in message
news:1142037215.646558.84890@.i40g2000cwc.googlegro ups.com...
> Hello All,
> I am trying to replicate data from a SQL Server (7.0) to another SQL
> Server using a one-way immediate push subscription. After executing,
> there are no errors in the Snapshot or Push agents, but two of the
> tables are missing in the subscription database. Where did they go?
>
> I can find the tables listed in the publication->articles tab and in
> the snapshot logs on the publisher. The tables are also listed on the
> subscriber database under 'Database Roles Properties' --> Permissions.
>
> Thank You For Your Time And Help,
> Nate
>
|||Everything looks as it should after calling sp_helpsubscription - the
two tables are listed.
|||This looks really strange. If you check the history messages of the snapshot
agent, do you see files for the two missing tables generated? And if you
check the distribution agent history, do you see that the files for the two
missing tables applied? If the tables are relatively small, you may be able
to fix things up by reinitializing the subscription, regenerate the snapshot
and reapply it. You may also want to watch out for processes outside of
replication that may have dropped the tables at the subscriber. What are the
sync_type values of subscriptions to the missing tables?
-Raymond
sql

Replication problems

Hi group
I have the following setup:
A primary sqlserver running windows 2000 server OS
a secondary sqlserver running windows 2003 server OS
Both sqlservers run sqlserver 2000 software, and both logon with the
local administrator account. Both administrator account have the same
password, so accessing \\<servername>\c$\....\repldata shouldnt be a
problem.
the primary sqlserver has been configured as the publication server,
publicating a database called repli_test, as snapshot
The secondary sqlserver has a pull subscription to the repli_test
database.
When I try to pull the database, I get the following error:
The job failed. Unable to determine if the owner
(SQL-BACKUP\Administrator) of job
SQLSERVER-repli_test-repli_test-SQL-BACKUP-repli_test-9DA1AF79-158C-49BD-89B6-64D8F9EF2C21
has server access
(reason: Could not obtain information about Windows NT group/user
'SQL-BACKUP\Administrator'. [SQLSTATE 42000] (Error 8198)).
any suggestions to a solution?
TIA
Kaare
Try changing the job owner to sa.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thank you very much for your reply. It really did the trick.
Unfortunally Im stock on another problem. Replication doesnt seem to
work, if a table contains more than 255 columns. Is there any workaround
on this issue?
TIA
Kaare
|||The main advised workaround is to partition the table and then replicate as
two articles in the same publication. From the point of view of the system,
this could be made transparent as you could have a view which unions the
data from the 2 tables, and call the view the same as the curent table. This
would be taking advantage of non-distributed partitioned views.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Replication problem(integrity violation) - Cannot Sync up emul

Hi
Unfortunately I am not an expert on replication!
Hilary Cotter who has replied in microsoft.public.sqlserver.replication
knows alot more about replication than I.
John
"steroche" wrote:

> Im afraid not. I have tried everything at this stage and its driving me
> crazy!!!!!
> I have re-published my database about 10times i'd say and i always get
> an error.
> Generally I get one of 2 errors. If i have already created the database
> the errors are:
> Message "Row data cannot be set. [,,,,,]"
> NativeError 28572
> and
> Message "Invalid row handle"
> NativeError 0
> However if i dont have it created previous to running it and it creates
> it itself I get the error:
> message "Run"
> NativeError 28557
> Message "The row update or insert cannot be reapplied due to an
> integrity violation. [,,,,,]
> NativeError 28549
> What the hell is going on' I have checked all the tables to make sure
> that the checkbox "Enforce Relationship for replication" IS checked so
> the NOT FOR REPLICATION bug doesn't apply here.
> I have checked over all my datatypes and relationships and the data
> that they contain to ensure that there can be no FK conflicts.
> I know the table is being created as i can see it on the CE Query
> analyser but it contains no tables so this probably gives rise to the
> second error but why is it not creating the db properly in the first
> place'
> I heard that compacting the db might help - how do i do that'
>Check that your subset filters and merge filters in the publication are
correctly constructed.
You are potentially sending down some data on a foreign key that is getting
filtered out.
Rob
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:F13AC93E-5354-4A2F-A066-2B3D22AA6D8F@.microsoft.com...
> Hi
> Unfortunately I am not an expert on replication!
> Hilary Cotter who has replied in microsoft.public.sqlserver.replication
> knows alot more about replication than I.
> John
> "steroche" wrote:
>sql

Replication Problem

I don't know if anyone can help with this, I've got replication running
between 2 SQLServer installations, the distributor is on the the same
server as subscriber. Replication is a once a day snapshot and all has
been working well until recently.

I needed to make a change to the replication and deleted and recreated
the subscription and now it doesn't work. The snapshot runs as before
but the subscription fails within a second or 2 with the following error:

"The process could not retrieve security information from the Subscriber
for Distributer 'MIServer'. The step failed."

The only thing I could think of was that somehow the password for the
'distributor_admin' login had become out of step. I've run
'sp_changedistributor_password' and the subscription still fails.

Any help would be appreciated.

TIA

Laurence Breeze"Laurence Breeze" <laurence_breeze@.yahoo.co.uk> wrote in message
news:4240096D.2000305@.yahoo.co.uk...
>I don't know if anyone can help with this, I've got replication running
>between 2 SQLServer installations, the distributor is on the the same
>server as subscriber. Replication is a once a day snapshot and all has
>been working well until recently.
> I needed to make a change to the replication and deleted and recreated the
> subscription and now it doesn't work. The snapshot runs as before but the
> subscription fails within a second or 2 with the following error:
> "The process could not retrieve security information from the Subscriber
> for Distributer 'MIServer'. The step failed."
> The only thing I could think of was that somehow the password for the
> 'distributor_admin' login had become out of step. I've run
> 'sp_changedistributor_password' and the subscription still fails.
> Any help would be appreciated.
> TIA
> Laurence Breeze

It sounds rather similar to this KB article:

http://support.microsoft.com/?id=312106

But you might get a better response in
microsoft.public.sqlserver.replication.

Simon

Replication over VPN

I think that the configuration for replication via VPN is the same as that
used on a LAN. But I can not register remote SQLserver by name and it does
not work by IP.
1. Does it work in case dynamic IP ?
2. Use alias name instead of IP address ?
3. Other recomendations .
Please help.
Thank you.
a vpn should be the same as a local lan. It will work by dynamic ip if it
can resolve the subscriber by host name. However, it sounds like you can't
do this. You need to work on the name resolution issue. It could be a
network connection problem. Tracert should help you to figure out where the
break is.
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
"Thang Long" <Thang Long@.discussions.microsoft.com> wrote in message
news:0F60A7B1-DF73-41F3-AF6F-9D3B64A3780E@.microsoft.com...
> I think that the configuration for replication via VPN is the same as that
> used on a LAN. But I can not register remote SQLserver by name and it does
> not work by IP.
> 1. Does it work in case dynamic IP ?
> 2. Use alias name instead of IP address ?
> 3. Other recomendations .
> Please help.
> Thank you.
>
>
|||Thank you for your reply.
The remote server named SERVER. Does it break naming rules ?
Many thanks.
Thang Long
"Hilary Cotter" wrote:

> a vpn should be the same as a local lan. It will work by dynamic ip if it
> can resolve the subscriber by host name. However, it sounds like you can't
> do this. You need to work on the name resolution issue. It could be a
> network connection problem. Tracert should help you to figure out where the
> break is.
> --
> 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
> "Thang Long" <Thang Long@.discussions.microsoft.com> wrote in message
> news:0F60A7B1-DF73-41F3-AF6F-9D3B64A3780E@.microsoft.com...
>
>
|||it might, I would try a fully qualified domain name in the alias section.
Also make sure there are no entries for it in
%windir%\system32\drivers\etc\hosts
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
"Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...[vbcol=seagreen]
> Thank you for your reply.
> The remote server named SERVER. Does it break naming rules ?
> Many thanks.
> Thang Long
> "Hilary Cotter" wrote:
it[vbcol=seagreen]
can't[vbcol=seagreen]
the[vbcol=seagreen]
that[vbcol=seagreen]
does[vbcol=seagreen]
|||Doesn't break rules, try to the following.
ping SERVER
If you see the IP address in the lines follwoing this request and it's the
correct IP the DNS is funcitoning properly.
If the IP address is wrong or no IP address is given you may need the
assistance of the network administrator. I've seen it where a new remote
client VPN tunnel had an access-list misconfigured that then wouldn't let it
pull DHCP/DNS information accross the tunnel.
HTH,
GTM
"Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...[vbcol=seagreen]
> Thank you for your reply.
> The remote server named SERVER. Does it break naming rules ?
> Many thanks.
> Thang Long
> "Hilary Cotter" wrote:
|||Where could I find step-by-step guide to setup sql replication between
non-trusted domains.
Thank you.
"Hilary Cotter" wrote:

> it might, I would try a fully qualified domain name in the alias section.
> Also make sure there are no entries for it in
> %windir%\system32\drivers\etc\hosts
> --
> 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
> "Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
> news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...
> it
> can't
> the
> that
> does
>
>
|||Paul, thank you. I try replication using VPN, but your article outlines what
to if a VPN is not available. Please tell me other articles.
Rgds,
"Paul Ibison" wrote:

> Thang,
> please take a look at this article:
> http://www.replicationanswers.com/InternetArticle.asp
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||If can not resolve the subscriber by host name. Could I use client network
utility to create alias name and cofigure replication ?
Thank you.
"Greg" wrote:

> Doesn't break rules, try to the following.
> ping SERVER
> If you see the IP address in the lines follwoing this request and it's the
> correct IP the DNS is funcitoning properly.
> If the IP address is wrong or no IP address is given you may need the
> assistance of the network administrator. I've seen it where a new remote
> client VPN tunnel had an access-list misconfigured that then wouldn't let it
> pull DHCP/DNS information accross the tunnel.
> HTH,
> GTM
>
> "Thang Long" <ThangLong@.discussions.microsoft.com> wrote in message
> news:61B0C5A5-B8AD-4003-A1E4-4EF2B64FA6C9@.microsoft.com...
>
>
|||Thang,
sorry - your question related to 'non-trusted domains' so I supposed you
were trying an alternative to the VPN setup. I don't know of any specialized
VPN articles.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Yes, use client network utility to create alias name and specify
alternate snapshot folder using IP adress.
This worked for me,
Adrian

Replication on SQL Server

Hi again,

I have a problem with replication on SQLServer 2000. I've started "Configure
Publishing and Distribution Wizard" and SQLSrvr posted message "SQLServer
Enterprise Manager colud not configure 'DANILOPOPOVIC' as the Distributor
for 'DANILOPOPOVIC'. Error 14234: The specified '@.Server' is invalid (valid
values are returned by sp_helpserver'. I didn't type server name "@.Server",
because I've used wizard.What is a problem?

Thank you in advance,

Danilo Popovi, B. Sc.
Trgostil d.d. - IC
Toplika 16
49240 Donja Stubica
CroatiaHi again,

I've tried the same thing on another server TRGO2000 and SQLSrvr posted
message "SQLServer Enterprise Manager colud not configure 'TRGO2000' as the
Distributor for 'TRGO2000'. Error 14114: '(null)' is not configured as a
Distributor. '.

Danilo Popovi, B. Sc.
Trgostil d.d. - IC
Toplika 16
49240 Donja Stubica
Croatia|||I had a similar problem using the Wizards to set replication with the
Version 7 of EM. It was because the servers were registered in the EM with a
different name to the Actual Server Name. So I would check that the Servers
are registered with the correct Server/Instance Name.

Hope this Helps

Cheers
Dean

"Danilo Popovi" <adf@.trgostil.hr> wrote in message
news:bku3va$6jj$1@.sunce.iskon.hr...
> Hi again,
> I have a problem with replication on SQLServer 2000. I've started
"Configure
> Publishing and Distribution Wizard" and SQLSrvr posted message "SQLServer
> Enterprise Manager colud not configure 'DANILOPOPOVIC' as the Distributor
> for 'DANILOPOPOVIC'. Error 14234: The specified '@.Server' is invalid
(valid
> values are returned by sp_helpserver'. I didn't type server name
"@.Server",
> because I've used wizard.What is a problem?
> Thank you in advance,
> Danilo Popovi, B. Sc.
> Trgostil d.d. - IC
> Toplika 16
> 49240 Donja Stubica
> Croatia
>
>

replication on port 80 with sqlServer 2005

Can replication be done over port 80 with SQL Server 2005?
This would remove the "hotel firewall blocks port 1433" scenario.......
Thanks
You can run SQL server on any port including 1433, or 80. Causes havoc with
web servers running on this port though.
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
"astro" <astro@.bcmn.com> wrote in message
news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
> Can replication be done over port 80 with SQL Server 2005?
> This would remove the "hotel firewall blocks port 1433" scenario.......
>
> Thanks
>
|||that makes sense...but how do you deal with traveling sales staff that need
to replicate on their hotel connection when all ports except 80 (web) and 25
(smtp) and 110 (pop3) have been locked down? Has anyone else ran into this?
Or maybe this is some other issue.....
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OAc0HoM$FHA.272@.TK2MSFTNGP09.phx.gbl...
> You can run SQL server on any port including 1433, or 80. Causes havoc
> with web servers running on this port though.
> --
> 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
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||I've noticed limitations are enforced if you enable web access in your
publication: first is the dynamic snapshots are not created or used as new
subs try to sync, 2nd you can use logical record, were replication can treat
joined tables as a transaction (order hdr/lines for example)
the new prepared dyn snap shots are awesome, our initial sync times went
from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
automatic...
also if you have the pub web enabled, yet still sync through the tradition
means (which you can, you can change it in the sub), dyn snapshouts still do
not work...
"astro" <astro@.bcmn.com> wrote in message
news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
> Can replication be done over port 80 with SQL Server 2005?
> This would remove the "hotel firewall blocks port 1433" scenario.......
>
> Thanks
>
|||sorry correction-- *CAN'T* use logical records
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
> I've noticed limitations are enforced if you enable web access in your
> publication: first is the dynamic snapshots are not created or used as new
> subs try to sync, 2nd you can use logical record, were replication can
> treat joined tables as a transaction (order hdr/lines for example)
> the new prepared dyn snap shots are awesome, our initial sync times went
> from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
> automatic...
> also if you have the pub web enabled, yet still sync through the tradition
> means (which you can, you can change it in the sub), dyn snapshouts still
> do not work...
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||I'll have to look at this.....
Thanks.
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
> I've noticed limitations are enforced if you enable web access in your
> publication: first is the dynamic snapshots are not created or used as new
> subs try to sync, 2nd you can use logical record, were replication can
> treat joined tables as a transaction (order hdr/lines for example)
> the new prepared dyn snap shots are awesome, our initial sync times went
> from 40mins to ~ 2mins!! (and it was 2+ hours on sql2000) and its all
> automatic...
> also if you have the pub web enabled, yet still sync through the tradition
> means (which you can, you can change it in the sub), dyn snapshouts still
> do not work...
> "astro" <astro@.bcmn.com> wrote in message
> news:3HZlf.1272$7S.24@.tornado.rdc-kc.rr.com...
>
|||cool!
sql2005 Merge replication speed is amazing now, makes sql2000 seem like the
stone age!!
"astro" <astro@.bcmn.com> wrote in message
news:hDhnf.9358$Dk.8912@.tornado.rdc-kc.rr.com...
> I'll have to look at this.....
> Thanks.
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:d10dc$439bed58$a227293d$4609@.ALLTEL.NET...
>

Replication Not working for a table

We have about 20 tables setup for replications . All std.
setup . Replication is using stored procs created by SQL
Server instead of the Statements. All tables are fine
except one table stpped changing data at all. No errors
etc.
What should I do.
Table has 2 coulms as PK . using SQL stored proc,
sp_msIns..,sp_msUpd.., sp_msdel..
What could be wrong. PLease help. All other tables are
fine.
No Primary key or columns have been changed at all .
ThanksYour table name contains white spaces or special characters? If so,
rename your stored procedures.
MoreThanInsane
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message1340150.html

Replication merge

Hi All
Can i compress and cryptography data in the replication merge process of SQL
SERVER 2000?
Where can i find some informations?
Thanks Alex
What you can do is register your servers in client network utiltity with the force protocol encryption option.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Alex" wrote:

> Hi All
> Can i compress and cryptography data in the replication merge process of SQL
> SERVER 2000?
> Where can i find some informations?
> Thanks Alex
>
>