Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-synchronization
Search options answers only
not deleted
user 150011
0
votes
Query differences between two tables with identical definitions
You can do something of the sort like this to generate a row hash (this uses the MD5() function but there are other hashing functions that reduce chances for collision as well):
SELECT STANDARD_HASH(( …
- 39.5k
3
votes
Is partial synchronisation possible between two databases on different servers?
This is possible if your synchronization methodology is via the Replication features of SQL Server, such as with Transactional Replication.
One minor limitation though is any schema bound objects (suc …
- 39.5k
1
vote
Pseudo-replication from read-only cloud SQL database to local SQL copy
None of the fancier replication options would work here, would they? (Pull replication, Merge replication, etc.)
You don't really have many options if it's a read-only database and you don't have ac …
- 39.5k
3
votes
How to ship new rows from the source to a target server?
It sounds like in this case, a simpler solution might be best for you, such as scheduling a daily SQL Agent job that INSERTS INTO the Target Database's Table the 10 million rows you need from your Sou …
- 39.5k
1
vote
How to handle two separate databases? MongoDB and PostgreSQL
Is it technically possible to connect Postgres and MongoDB together in a way where we can see a link between user accounts in both DBs?
Not easily, natively.
You'll likely either need to build, buy …
- 39.5k
0
votes
Setting up cloud database for syncing to local SQLite database
While CDC is one useful methodology in SQL Server, it can also be a little performance heavy too depending on how much data and how frequently it changes.
You might want to consider a 3rd party tool t …
- 39.5k
3
votes
Accepted
What are the performance implications of using checksums vs change tracking for SQL Server
Is the difference in performance between using checksum calculations and change tracking worth pursuing?
Yea, most likely in your use case. This is because of the frequency of which you're checking …
- 39.5k