Bulk update a database
Methods to bulk update a database with single or multiple columns of data. This could be either unique data for each row or same data for a column.
Questions tagged [bulkupdate]
299 questions
0
votes
1 answer
C# - Can BulkInsert() automatically truncate strings that are too long?
I am using a lot of bulk insert calls similar to this:
List
Jeremy P
- 1,309
- 2
- 13
- 22
0
votes
1 answer
How to implement bulk update with sequelize?
I have tried here but I'm not getting correct answer this code will update only one record but I have to update multiple records at a time with different ids and I supposed to pass different ids as an endpoint to an API.
async function…
Chandan
- 1
- 1
0
votes
1 answer
MongoDB BulkWrite ExceededTimeLimit error in .Net
I'm trying to push about 150k updates into Mongo database (v 4.2.9 running on Windows, stage replica with two nodes) using BulkWrite on c# driver (v2.11.6) and looks like it is impossible. The project is .Net Framework 4.7.2.
Mongo c# driver…
Martin Brabec
- 3,720
- 2
- 23
- 26
0
votes
0 answers
Best approach to Read bulk records and update individual records without locking table
Here is my code and I am looking for best approach without locking records while updating.
Declare @maxRowId int
Set @maxRowId=0
Declare @rowIndex int
Set @rowIndex=1
Declare @recordId bigint
Set @recordId=0
Begin Try
Declare…
techSC
- 1
0
votes
1 answer
The transaction log for database is full due to 'LOG_BACKUP'
We are doing a delete from a few tables in one database (say FirstDB), and will insert about 93,357 rows (one row at a time ) into one Log table in another database (say SecondDB).
The databases Recovery Model is Full.
Each row contains 6 columns of…
faujong
- 949
- 4
- 24
- 40
0
votes
0 answers
SQL Server using Except vs Binary_Checksum
I am using SQL Server and want to do Bulk Updates but don't want any row to be re-updated if same values already exists.
For Example Consider following tables with their data
DECLARE @UpdatedIds TABLE
(
BookId INT
)
CREATE TABLE Book
(
…
Muhammad Mutahar Alam
- 163
- 1
- 1
- 12
0
votes
1 answer
Bulk update and return Id of failed updates in JPA/Hibernate
{
events:
[
{"id": "1"}
{"id": "2"}
]
attributes:
[
{
"field": "field1"
"value": "value1"
}
{
"field": "field2"
"value": "value2"
}
]
}
For the above input i would like to update column "field": "field1" of row "id": "1" with "value": "value1"…
Sourabh
- 119
- 1
- 8
0
votes
0 answers
Doctrine ORM, issue with Bulk Updates using persist and flush when each entity has nested relations (Possibility to use Cache)
I am trying to do an excel import of product data where the excel will have data which is already existing in the database. So it turns out to be updating the existing product data from the values coming from excel. Each product data has relations…
Kiran Krishnan
- 30
- 5
0
votes
0 answers
PHP 7.3 PDO - SQLServer - Bulk Upgrade Issue
I receive an XML file that contains the updated details of the inventory and
I need to process the xml to update the database.
Currently the routine looks like this:
$SQL = "EXEC sp__ReviseInventoryStatus :ItemID,:Quantity,:Price";
$rs=…
Joe
- 1,033
- 1
- 16
- 39
0
votes
2 answers
Elasticsearch bulk upsert with query on specific field
There is an index with this mapping:
"data": {
"type": "object"
},
"modified_date": {
"type": "date"
},
"uid": {
"type": "keyword"
}
Now I want to do a bulk operation for upsert (Update if exists and insert if not exists). The query is on…
pedram
- 335
- 1
- 4
- 19
0
votes
1 answer
Issue using Django api for bulk creating and updating records by csv
New to django and working on bulk creating and updating rows in my database using csv. I am using this:
https://pypi.org/project/django-bulk-update-or-create/#description
I can get the first option: bulk_update_or_create working fine but when I use…
Tortoise1990
- 53
- 2
0
votes
1 answer
Update each row with a new entity
I have two tables:
CREATE TABLE public.test
(
id integer NOT NULL GENERATED ALWAYS AS IDENTITY
)
and
CREATE TABLE public.test2
(
id integer,
test_id integer
)
Table test2 has two rows (1, null) and (2, null). Table test has nothing.…
Serg046
- 1,043
- 1
- 13
- 42
0
votes
1 answer
Bulk insert/update with umongo
I would like to perform bulk insert/update with the umongo library in Python. Is there a way to do the bulk update all at once or am I going to run one insert/update job per item to update ?
Robin Nicole
- 113
- 2
- 8
0
votes
1 answer
FileNet Bulk action to update security folder property based on folder filed in
I have a set of a few thousand FileNet documents that need to have the security reset from the document level to the folder level. Does anyone know if there is a document set security folder method as well as to be able to obtain the object…
Schulzpack
- 1
- 1
0
votes
0 answers
Bulk updating ActiveRecord objects in Rails
I've got about 60,000 records I want to update. The issue I'm having is that the migration that iterates over them takes too long to run. I'm considering a bulk upsert, but not quite sure how that would look in practice.
Here's what I currently…
rustyshackleford
- 692
- 1
- 7
- 22