Linked Questions
14 questions linked to/from SQL Server Many-to-One replication
2
votes
2
answers
787
views
Replication with two publishers [duplicate]
I have three servers with own databases, and database schemas are same. Let's call them servers A, B and C.
All three servers will be operational, which means that all three servers will serve for ...
- 815
3
votes
3
answers
5k
views
Use sp_Blitz to gather information on all servers in a centralized server/database
I am using sp_Blitz, and want to use it to execute the checks on all of my SQL Servers and have it write the results to a single table.
Do I need to create linked servers on the central instance to ...
- 511
5
votes
2
answers
2k
views
Copy data from multiple databases to a central database for reporting and analysis
I have more than 8 databases and all are in a SQL Server environment. I need to extract data from specific tables (more than 50 tables) of each database and dump into a central database for reporting ...
- 51
5
votes
2
answers
2k
views
Many-to-One replication / Transactional Replication
I have several PostgreSQL DBs in different geographical locations (local sites).
Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, ...
- 51
10
votes
3
answers
290
views
Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database
I am a SQL Developer (not DBA or Architect) for a small (~50 employees) SaaS company. I am tasked with figuring out how to:
Offload operational reporting from our 100+ OLTP databases
Allow those ...
- 101
2
votes
1
answer
1k
views
Log Shipping vs Data Replication in SQL Server 2012
Just wonder if anyone has tried to use Log Shipping on SQL Server 2012 collecting data from SQL Server 2008R2 and SQL Server 2005 databases? I heard it would be an easier option to implement compared ...
- 133
4
votes
3
answers
761
views
Initializing Transactional Replication From two Different Database Backup
I have two different large Database (200GB for each) which I want to replicate their data to a central database (3rd DB). I followed this link and it was very useful for a single database.
But my ...
3
votes
1
answer
806
views
AlwaysOn AG and Cross-Database/Server Transactions
We're about to move from SQL Server 2008 R2 Standard to SQL Server 2012 Enterprise and are reviewing or HA as part of process. Right now we use DPM and log shipping every 15 mins. Our MS partner is ...
- 211
2
votes
1
answer
979
views
Is it possible to have one server acting as secondary for two primaries on AG?
Can I have a server acting as secondary replica for two primary servers on an availability group?
If possible, are there some concerns about performance in an async environment? Are listeners going ...
1
vote
0
answers
774
views
Is it possible to synchronize multiple databases in to 1 database with the same tables?
We are facing a situation where we have 5 different businesses with comparable data and are building 1 single application to deliver their data to common customers.
In order to do this, the plan is ...
- 111
1
vote
1
answer
247
views
Merge Replication From Multiple Express to Central
So I am trying to setup a merge replication from multiple remote SQL 2016 Express installations to a central SQL 2016 Server. This would be for reporting purposes so I would need all the express ...
- 43
2
votes
1
answer
130
views
SQL Server: How does Uniquifier work with Replication?
In SQL Server, if I have a non-unique clustered index on a table, how does replication work for that table?
For example:
CREATE TABLE MyData (
MyDataID uniqueidentifier not null,
MyData ...
- 123
3
votes
0
answers
113
views
Should I use Transactional Replication here?
I have a database on SQL Server A & one on SQL Server B. (SQL 2017 w/ enterprise) They share similar objects and need to be kept fairly up to date. Both will require changes to be passed to each ...
- 680
3
votes
1
answer
63
views
Initialize replication sql server from backup of many databases
I want to know how I can initialize a subscription from a backup of a publication database. I have three diferent databases that will point to the same subscriber. For the first time there is no ...
