Anyone know of a chart on the Microsoft Site that compares all the
Replication types for SQL 2005?
Trans Shipping, Mirroring, Publication and Subscription and all that
stuff?
Here is a pretty good one on the Dell site.
www.dell.com/downloads/global/power/ps1q06-20050325-Sankaran.pdf
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
"jughead" <mike.aarset@.gmail.com> wrote in message
news:1174056604.344365.92450@.o5g2000hsb.googlegrou ps.com...
> Anyone know of a chart on the Microsoft Site that compares all the
> Replication types for SQL 2005?
> Trans Shipping, Mirroring, Publication and Subscription and all that
> stuff?
>
Showing posts with label types. Show all posts
Showing posts with label types. Show all posts
Friday, March 23, 2012
Saturday, February 25, 2012
replication
hey anybody knows where i will get detail information on
SQLServer 2000 Replication?
i want to go through all replication types?
Please let me know
thanks and regards
hrishikeshCheck
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"hrishikesh" <musaleh@.mahindrabt.com> wrote in message
news:094901c36df2$58d6c810$a301280a@.phx.gbl...
> hey anybody knows where i will get detail information on
> SQLServer 2000 Replication?
> i want to go through all replication types?
> Please let me know
> thanks and regards
> hrishikesh
>
SQLServer 2000 Replication?
i want to go through all replication types?
Please let me know
thanks and regards
hrishikeshCheck
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replover_694n.asp.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"hrishikesh" <musaleh@.mahindrabt.com> wrote in message
news:094901c36df2$58d6c810$a301280a@.phx.gbl...
> hey anybody knows where i will get detail information on
> SQLServer 2000 Replication?
> i want to go through all replication types?
> Please let me know
> thanks and regards
> hrishikesh
>
Replicating with Access in Hilary's book
On page 50, you discuss replicating SQL Server to Access. Two questions:
1. While you discuss all 3 replication types, it sounds like you are
recommending Merge as the solution?
2. In the hint, it says in part, "all transactions occuring on the Merge
Subscriber [Access] will be "published" or merged to the SQL Server
database." Do you mean the transactions are merged on the SQL Server's
schedule (both directions?) or via some user interaction on the Access side?
1) while you can use snapshot, transactional, or merge replication; what I
was trying to get at was that many people want the access database to
publish to sql server, and I was suggesting that you could set up the access
database as a subscriber and if all the changes originate there it could act
as the publisher.
2) All transactions will be merged with the publisher, but they all
originate with the subcriber/access database. the synchronization will be
kicked off each time the push agent runs - I don't believe you can do a
pull.
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%239ZFAV2cFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On page 50, you discuss replicating SQL Server to Access. Two questions:
> 1. While you discuss all 3 replication types, it sounds like you are
> recommending Merge as the solution?
> 2. In the hint, it says in part, "all transactions occuring on the Merge
> Subscriber [Access] will be "published" or merged to the SQL Server
> database." Do you mean the transactions are merged on the SQL Server's
> schedule (both directions?) or via some user interaction on the Access
> side?
>
1. While you discuss all 3 replication types, it sounds like you are
recommending Merge as the solution?
2. In the hint, it says in part, "all transactions occuring on the Merge
Subscriber [Access] will be "published" or merged to the SQL Server
database." Do you mean the transactions are merged on the SQL Server's
schedule (both directions?) or via some user interaction on the Access side?
1) while you can use snapshot, transactional, or merge replication; what I
was trying to get at was that many people want the access database to
publish to sql server, and I was suggesting that you could set up the access
database as a subscriber and if all the changes originate there it could act
as the publisher.
2) All transactions will be merged with the publisher, but they all
originate with the subcriber/access database. the synchronization will be
kicked off each time the push agent runs - I don't believe you can do a
pull.
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
"Earl" <brikshoe@.newsgroups.nospam> wrote in message
news:%239ZFAV2cFHA.1044@.TK2MSFTNGP10.phx.gbl...
> On page 50, you discuss replicating SQL Server to Access. Two questions:
> 1. While you discuss all 3 replication types, it sounds like you are
> recommending Merge as the solution?
> 2. In the hint, it says in part, "all transactions occuring on the Merge
> Subscriber [Access] will be "published" or merged to the SQL Server
> database." Do you mean the transactions are merged on the SQL Server's
> schedule (both directions?) or via some user interaction on the Access
> side?
>
Replicating User Defined Data Types
Hey guys,
Thanks so much for this great newsgroup btw, helped me hugely through doing
replication via handheld units etc.
I'm running into a bit of a problem between server 2 server replication.
Both databases have user defined data types. All the tables using them are
fine, but once the snapshot is applied to the subscriber, and the replication
is hooked up to the publisher, all the data types are converted to their base
types (char 10 etc)
Is there any way to stop this? The subscriber needs to keep the user defined
data types.
I noticed in the publication wizard there is an option that says "Keep the
existing table unchanged" but the default value for this is "DROP the
existing table and re-create it" this is all under the Snapshot tab of the
article properties.
If I set it to "Keep the existing table unchanged" will that fix my problems
or is that not the proper fix for this issue?
Thanks and take care!
Simon,
on the article propertuies at the bottom there is the option to change user
defined datatypes to base types and by default this is enabled. Also, you
can add the user defined types themselves to a prescript.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Thanks so much for this great newsgroup btw, helped me hugely through doing
replication via handheld units etc.
I'm running into a bit of a problem between server 2 server replication.
Both databases have user defined data types. All the tables using them are
fine, but once the snapshot is applied to the subscriber, and the replication
is hooked up to the publisher, all the data types are converted to their base
types (char 10 etc)
Is there any way to stop this? The subscriber needs to keep the user defined
data types.
I noticed in the publication wizard there is an option that says "Keep the
existing table unchanged" but the default value for this is "DROP the
existing table and re-create it" this is all under the Snapshot tab of the
article properties.
If I set it to "Keep the existing table unchanged" will that fix my problems
or is that not the proper fix for this issue?
Thanks and take care!
Simon,
on the article propertuies at the bottom there is the option to change user
defined datatypes to base types and by default this is enabled. Also, you
can add the user defined types themselves to a prescript.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Monday, February 20, 2012
Replicating same table twice in different publication types
I have a table that I need to replicate twice. Once as part of an updating
subscriber transactional publication and once as a plain transactional repliaction.
This table has an identity column, which is causing the problem.
If I set the identity management to false, it complains that it conflicts
with how the article is already published. If I say true, then it complains
that this setting is ony requierd for updating subscriber publications.
Is there any way around this?
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Hi Simon,
To let me better understand your issue, I would like to know the following
questions:
1. What do you mean replicate the table twice?
2. What is your SQL Server version?
3. What are the detailed steps so that I can reproduce your issue?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||There are some publication properties which will affect an article for all
subsequent publications using this article.
This is one of them. One of the things you can do is use manual identity
range management if you have small numbers of subscribers.
"Simon Sabin" <SimonSabin@.noemail.noemail> wrote in message
news:62959f1a5b90c8c94fc14a0e5941@.msnews.microsoft .com...
> I have a table that I need to replicate twice. Once as part of an updating
> subscriber transactional publication and once as a plain transactional
> repliaction.
> This table has an identity column, which is causing the problem.
> If I set the identity management to false, it complains that it conflicts
> with how the article is already published. If I say true, then it
> complains that this setting is ony requierd for updating subscriber
> publications.
> Is there any way around this?
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||Hello Charles Wang[MSFT],
create a transaction replication publication with updating subscribers
create a table with an identity column
publish the table with identity management to auto
subscribe to the publication and table from one database
create a normal transactional replication publication
add the same table as an article. --This fails due tot he constraint on
the identity range management.
I want to do this because we have a scale out replication to architecture.
We run our websites against a subscriber DBs to distribute load.
I want to also puiblish to reporting server
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> Hi Simon,
> To let me better understand your issue, I would like to know the
> following
> questions:
> 1. What do you mean replicate the table twice?
> 2. What is your SQL Server version?
> 3. What are the detailed steps so that I can reproduce your issue?
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx
> #notif
> ications
> If you are using Outlook Express, please make sure you clear the check
> box "Tools/Options/Read: Get 300 headers at a time" to see your reply
> promptly.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent
> issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each
> follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach
> the
> most efficient resolution. The offering is not appropriate for
> situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are
> best
> handled working with a dedicated Microsoft Support Engineer by
> contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
|||Hi Simon,
I understand your concern.
Since this is a product limitation, the replication could not be
implemented if there is Identity confiliction.
I recommend that you assign discrete ID value range for the table in
different publication.
For example:
publisher1.tblTest has the identity range:
[1-10000],[20001-30000],[40001-50000],[60001-70000],........
publsher2.tblTest has the identity range: [10001-20000], [30001-40000],
[50001-60000],.............
You can create a trigger for the table [tblTest], on publisher1, when the
current identity value reaches to the one max value in [10000, 30000,
50000,..., (2n+1)*10000,...] (n>=0), jump the current identity id to the
next minimal value in [1,20001,40001,...,2n*10000+1,...] (n>=0) by using
"DBCC CHECKIDENT";
on publisher2, you can use the same way, but the max values are in the set
[20000,40000,..., 2n*10000,...] (n>=1) while the min values
[10001,30001,...,(2n-1)*10000+1] (n>=1).
By this way, the two publications can work together without identity
confliction.
Hope this helps. If you have any other questions or concerns, please feel
free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Simon,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
subscriber transactional publication and once as a plain transactional repliaction.
This table has an identity column, which is causing the problem.
If I set the identity management to false, it complains that it conflicts
with how the article is already published. If I say true, then it complains
that this setting is ony requierd for updating subscriber publications.
Is there any way around this?
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
Hi Simon,
To let me better understand your issue, I would like to know the following
questions:
1. What do you mean replicate the table twice?
2. What is your SQL Server version?
3. What are the detailed steps so that I can reproduce your issue?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||There are some publication properties which will affect an article for all
subsequent publications using this article.
This is one of them. One of the things you can do is use manual identity
range management if you have small numbers of subscribers.
"Simon Sabin" <SimonSabin@.noemail.noemail> wrote in message
news:62959f1a5b90c8c94fc14a0e5941@.msnews.microsoft .com...
> I have a table that I need to replicate twice. Once as part of an updating
> subscriber transactional publication and once as a plain transactional
> repliaction.
> This table has an identity column, which is causing the problem.
> If I set the identity management to false, it complains that it conflicts
> with how the article is already published. If I say true, then it
> complains that this setting is ony requierd for updating subscriber
> publications.
> Is there any way around this?
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||Hello Charles Wang[MSFT],
create a transaction replication publication with updating subscribers
create a table with an identity column
publish the table with identity management to auto
subscribe to the publication and table from one database
create a normal transactional replication publication
add the same table as an article. --This fails due tot he constraint on
the identity range management.
I want to do this because we have a scale out replication to architecture.
We run our websites against a subscriber DBs to distribute load.
I want to also puiblish to reporting server
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
> Hi Simon,
> To let me better understand your issue, I would like to know the
> following
> questions:
> 1. What do you mean replicate the table twice?
> 2. What is your SQL Server version?
> 3. What are the detailed steps so that I can reproduce your issue?
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> Get notification to my posts through email? Please refer to:
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx
> #notif
> ications
> If you are using Outlook Express, please make sure you clear the check
> box "Tools/Options/Read: Get 300 headers at a time" to see your reply
> promptly.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent
> issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each
> follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach
> the
> most efficient resolution. The offering is not appropriate for
> situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are
> best
> handled working with a dedicated Microsoft Support Engineer by
> contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ================================================== ====
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ================================================== ====
|||Hi Simon,
I understand your concern.
Since this is a product limitation, the replication could not be
implemented if there is Identity confiliction.
I recommend that you assign discrete ID value range for the table in
different publication.
For example:
publisher1.tblTest has the identity range:
[1-10000],[20001-30000],[40001-50000],[60001-70000],........
publsher2.tblTest has the identity range: [10001-20000], [30001-40000],
[50001-60000],.............
You can create a trigger for the table [tblTest], on publisher1, when the
current identity value reaches to the one max value in [10000, 30000,
50000,..., (2n+1)*10000,...] (n>=0), jump the current identity id to the
next minimal value in [1,20001,40001,...,2n*10000+1,...] (n>=0) by using
"DBCC CHECKIDENT";
on publisher2, you can use the same way, but the max values are in the set
[20000,40000,..., 2n*10000,...] (n>=1) while the min values
[10001,30001,...,(2n-1)*10000+1] (n>=1).
By this way, the two publications can work together without identity
confliction.
Hope this helps. If you have any other questions or concerns, please feel
free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi Simon,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Charles Wang
Microsoft Online Community Support
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
Subscribe to:
Posts (Atom)