SQL Server Web transaction replication to Azure SQLHow to restore replication after server crashModifying...
Journal losing indexing services
Bob has never been a M before
Did US corporations pay demonstrators in the German demonstrations against article 13?
anything or something to eat
Do Legal Documents Require Signing In Standard Pen Colors?
Could the E-bike drivetrain wear down till needing replacement after 400 km?
Will adding a BY-SA image to a blog post make the entire post BY-SA?
Engineer refusing to file/disclose patents
Gibbs free energy in standard state vs. equilibrium
How does the reference system of the Majjhima Nikaya work?
How must one send away the mother bird?
Can a Necromancer reuse the corpses left behind from slain undead?
MAXDOP Settings for SQL Server 2014
Visiting the UK as unmarried couple
Should I stop contributing to retirement accounts?
Why did the EU agree to delay the Brexit deadline?
Two-sided logarithm inequality
How much character growth crosses the line into breaking the character
How can Trident be so inexpensive? Will it orbit Triton or just do a (slow) flyby?
Proving a function is onto where f(x)=|x|.
Have I saved too much for retirement so far?
How can "mimic phobia" be cured or prevented?
Is there a conventional notation or name for the slip angle?
Can I sign legal documents with a smiley face?
SQL Server Web transaction replication to Azure SQL
How to restore replication after server crashModifying replication distributor & publisherMultiple Distributors in SQL Server ReplicationReplication ConfigurationDistribution Server (1) Replicating Source Server (2) To Destination Server (3)Two-step Replication between SQL 2008 and 2017Unable to enable publishing on restored databasehow azure sql geo replication works internally?Sql Server : How to query list of subscriptions and Articles (for a given publication) from PublisherConfigure replication from SQL server 2014 Enterprise Ed. to SQL server 2017 Enterprise Ed
In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution
In attempting to create the publication, I get This edition of SQL Server cannot act as a Publisher or Distributor for replication., which is expected as my server is Web edition.
So how do I set up Web edition replication to Azure SQL, given that it is a supported feature?
sql-server azure-sql-database
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution
In attempting to create the publication, I get This edition of SQL Server cannot act as a Publisher or Distributor for replication., which is expected as my server is Web edition.
So how do I set up Web edition replication to Azure SQL, given that it is a supported feature?
sql-server azure-sql-database
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution
In attempting to create the publication, I get This edition of SQL Server cannot act as a Publisher or Distributor for replication., which is expected as my server is Web edition.
So how do I set up Web edition replication to Azure SQL, given that it is a supported feature?
sql-server azure-sql-database
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
In Features for SQL Server 2016, I see that Transactional replication to Azure is supported for Web edition. Following the instructions leads to Configure Publishing and Distribution
In attempting to create the publication, I get This edition of SQL Server cannot act as a Publisher or Distributor for replication., which is expected as my server is Web edition.
So how do I set up Web edition replication to Azure SQL, given that it is a supported feature?
sql-server azure-sql-database
sql-server azure-sql-database
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
asked Dec 26 '16 at 14:02
Jeow Li HuanJeow Li Huan
1163
1163
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 5 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f159191%2fsql-server-web-transaction-replication-to-azure-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
add a comment |
According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
add a comment |
According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
According to Xiaochen Wu (Senior Program Manager at Microsoft), there is an error in the documentation. Web edition does not support transaction replication to Azure SQL.
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
answered Dec 27 '16 at 2:06
Jeow Li HuanJeow Li Huan
1163
1163
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f159191%2fsql-server-web-transaction-replication-to-azure-sql%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
