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?
-
0
Hi,
ABP provides data seed system: https://docs.abp.io/en/abp/latest/Data-Seeding
Is it suitable for you?
No, its not suitable for this
-
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/
-
0
any other way during deployment i need run the the script becuase i have lakhs of data
-
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
