Linked Server vs Replication vs Other?SQL Server Linked Server PermissionsConnecting Linked ServerSql Server...
What happens if you declare more than $10,000 at the US border?
What does an unprocessed RAW file look like?
What dissuades people from lying about where they live in order to reduce state income taxes?
Which was the first story to feature space elevators?
What caused Doctor Strange to repent of his selfishness and become Earth's protector?
The Late Queen Gives in to Remorse - Reverse Hangman
Are encryption algorithms with fixed-point free permutations inherently flawed?
Buying a "Used" Router
How to know if I am a 'Real Developer'
How can I make my enemies feel real and make combat more engaging?
Relation between roots and coefficients - manipulation of identities
Why is ra lower than re while la is higher than le?
Why don't reads from /dev/zero count as I/O?
Is it common to refer to someone as "Prof. Dr. [LastName]"?
What does the expression "Happy is as happy does" mean?
Why is quixotic not Quixotic (a proper adjective)?
Is Apex Sometimes Case Sensitive?
Where can I educate myself on D&D universe lore, specifically on vampires and supernatural monsters?
A semicolon (';') is not needed after a function declaration. C++
Identical projects by students at two different colleges: still plagiarism?
Have any astronauts or cosmonauts died in space?
Why does finding small effects in large studies indicate publication bias?
Taking an academic pseudonym?
Does changing "sa" password require a SQL restart (in mixed mode)?
Linked Server vs Replication vs Other?
SQL Server Linked Server PermissionsConnecting Linked ServerSql Server Linked ServerLinked server issueReplication and linked server securityLoopback Linked ServerSQL Server 2016: Bidirectional Transactional Replication using Backup, Do I use/need Snapshot?Linked Server with Failover - One works then other doesnt both to the same serverHow can we manage cross-database dependencies across environments?SQL Server - Query Over Linked Server to IBM DB2 throws an error
I've been thrown into a project where this business partner is pushing for transactional replication from our sql server to their sql server (which are on the same network/domain) for records from "just one table" in a database. I asked him if sending a remote query (linked server etc.) could satisfy his need and they are refusing to even consider it. I've explained that there have been improvements made to linked servers & if due diligence is practiced, linked servers can perform well and personally I see linked servers used all the time.
Thoughts? Other ideas? Scalability concerns? Enterprise Edition is being used on fairly robust servers.
I just feel that my people shouldn't have to be burdened with maintaining any replication that is put in place on something that I feel is simple. Unless SELECT * is all they code then... maybe t-repl is what is needed...
sql-server replication linked-server
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
add a comment |
I've been thrown into a project where this business partner is pushing for transactional replication from our sql server to their sql server (which are on the same network/domain) for records from "just one table" in a database. I asked him if sending a remote query (linked server etc.) could satisfy his need and they are refusing to even consider it. I've explained that there have been improvements made to linked servers & if due diligence is practiced, linked servers can perform well and personally I see linked servers used all the time.
Thoughts? Other ideas? Scalability concerns? Enterprise Edition is being used on fairly robust servers.
I just feel that my people shouldn't have to be burdened with maintaining any replication that is put in place on something that I feel is simple. Unless SELECT * is all they code then... maybe t-repl is what is needed...
sql-server replication linked-server
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
2
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago
add a comment |
I've been thrown into a project where this business partner is pushing for transactional replication from our sql server to their sql server (which are on the same network/domain) for records from "just one table" in a database. I asked him if sending a remote query (linked server etc.) could satisfy his need and they are refusing to even consider it. I've explained that there have been improvements made to linked servers & if due diligence is practiced, linked servers can perform well and personally I see linked servers used all the time.
Thoughts? Other ideas? Scalability concerns? Enterprise Edition is being used on fairly robust servers.
I just feel that my people shouldn't have to be burdened with maintaining any replication that is put in place on something that I feel is simple. Unless SELECT * is all they code then... maybe t-repl is what is needed...
sql-server replication linked-server
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
I've been thrown into a project where this business partner is pushing for transactional replication from our sql server to their sql server (which are on the same network/domain) for records from "just one table" in a database. I asked him if sending a remote query (linked server etc.) could satisfy his need and they are refusing to even consider it. I've explained that there have been improvements made to linked servers & if due diligence is practiced, linked servers can perform well and personally I see linked servers used all the time.
Thoughts? Other ideas? Scalability concerns? Enterprise Edition is being used on fairly robust servers.
I just feel that my people shouldn't have to be burdened with maintaining any replication that is put in place on something that I feel is simple. Unless SELECT * is all they code then... maybe t-repl is what is needed...
sql-server replication linked-server
sql-server replication linked-server
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
asked 13 hours ago
Eric SwiggumEric Swiggum
13413
13413
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
2
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago
add a comment |
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
2
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
2
2
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago
add a comment |
0
active
oldest
votes
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%2f230318%2flinked-server-vs-replication-vs-other%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f230318%2flinked-server-vs-replication-vs-other%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
how big is the table and how stale the data can be ? Are there any frequent changes done to schema e.g. adding new columns etc ?
– Kin
13 hours ago
2
Ask them if they're going to support Replication once it's set up.
– Erik Darling
13 hours ago
7.5 million rows on the main table & it needs to be "near-real time". There shouldn't be any schema changes. Then they say they need to "fan out" the data when it reaches their server, whatever that means & they don't even really have what they need defined so this is crazy.
– Eric Swiggum
12 hours ago
"they don't even really have what they need defined" - our problem is the same as yours. I'd push back to get some formal requirements written up, at least, before looking into options.
– LowlyDBA
10 hours ago