A SQL statement typically used to `UPDATE` records when they exist and `INSERT` them when they do not.
1
vote
1answer
37 views
Help with best practice of merging databases
Bad news, our website server (Windows 2003) crashed because of dead RAID controller.
Luckily few hours later our backup server was up and website was live again.
Hopefully tomorrow our original ...
0
votes
0answers
52 views
Transfer tables from multiple servers into one single server [duplicate]
I have to migrate similar tables present in multiple different servers (30+) into our new server using SSIS package. What would be the right approach towards this?
I was successfully able to transfer ...
1
vote
1answer
64 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
1
vote
1answer
56 views
Equivalent of MRG_MYISAM in databases other than MySQL? [closed]
Does anyone know if other database have something equivalent to MRG_MYISAM (aka the MERGE table type/storage engine)?
I know about fragmenting, but this is not quite the same AFAIK. We're using ...
1
vote
2answers
32 views
getting error when i use merge statement
I am using sql 2008 r2. when i use merge statement i am gettig error
when i execute following code:
merge products as trgt
using updatedproducts as src
on (trgt.productid = src.productid)
...
0
votes
0answers
33 views
Merge Replication is Slow for Uploads
I have implemented merge replication with pull subscriptions in production environment. Initially it was working fine, but now a days, its too slow to upload any changes to publisher , but subscribers ...
0
votes
0answers
22 views
What will happen if i change the compatibility level of Distribution Database [duplicate]
I have implemented merge replication in production environment, initially it was in SQL Server 2005, then it was upgraded in-line to SQL Server 2008 R2. Later on all databases compatibility level was ...
0
votes
0answers
33 views
Performance While merging two mysql DBs
I have two similar schema DBs which I need to merge. I was thinking about the performance issues which I need to keep in mind while creating the script. These are the ones which I can think of.
...
6
votes
1answer
691 views
MERGE a subset of the target table
I am trying to use a MERGE statement to insert or delete rows from a table, but I only want to act on a subset of those rows. The documentation for MERGE has a pretty strongly worded warning:
It ...
1
vote
1answer
101 views
Is there a way to write intelligent queries against a merge table in MySQL that represents a bunch of tables partitioned by date?
I have a set of MySQL tables that are partitioned by date, with a merge table representing all of them. For the query I am writing, the results are joined by date, so rows in table A_2012-12-05 will ...
4
votes
1answer
192 views
MERGE with OUTPUT doesn't seem to be doing the right thing
I'm adding a foreign key to a table, and removing any rows that violate the FK, copying them into a ModifiedTable_invalid table. As part of the script, I've got the following MERGE command:
MERGE ...
2
votes
2answers
456 views
Merge two records in the same table, keeping foreign key relationships intact for both
I have a table, called SITES, that has three columns, lets say it looks like this:
ID Name Path
1 Google http://www.google.com/
2 Microsoft http://www.microsoft.com/
I also have ...
2
votes
1answer
150 views
oracle merge operation hangs (or loops); query tuner claims it's a cartesian product operation
I have a Merge query (open to better suggestions) that seems to cause the server to hang. (I'm not sure what it's doing, but it pegs the CPU and never completes) When I run it through the query ...
2
votes
0answers
52 views
Once in a while synchronization of the independently updated mysql databases problem
I have a production database and a test database running on MySQL with MyISAM and InnoDB tables, which are updated independently.
The Production database is updated by system and sometimes by a user.
...
5
votes
3answers
2k views
SQL Server 2008 merge statement deadlocking itself
I have the following procedure (SQL Server 2008r2):
create procedure usp_SaveCompanyUserData
@companyId bigint,
@userId bigint,
@dataTable tt_CoUserdata readonly
as
begin
set ...
