I need to run the insert script with lakhs of data after deployment am not able to do manually because prod server we have no access so need to execute the script programatically its possible in ABP ? or for DB migration execute with both schema and data for particular table alone ?
Note : I have 1.5 lakhs of data in single table.
- ABP Framework version: 4.4.4
- UI type: Blazor
- DB provider: EF Core
- Tiered (MVC) or Identity Server Separated (Angular): no
- Exception message and stack trace:
- Steps to reproduce the issue:"
5 Answer(s)
-
0
Hi,
ABP provides data seed system: https://docs.abp.io/en/abp/latest/Data-Seeding
Is it suitable for you?
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
You want to execute SQL script right?
Can you check this: https://dejanstojanovic.net/aspnet/2020/september/seeding-data-in-ef-core-using-sql-scripts/
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post) -
0
Hi,
Sorry, I don't know what's blocking you.
execute the script programatically its possible in ABP ?
This is possible, you can make SQL script as embedded files and execute the SQL script during program runtime
Markdown supported.Copy, paste, or drag & drop images and files (max 100 MB per file, 100 MB total per post)
