Need advice on migrating changes to database in production environment #7588

5 Answer(s)

• 

  0

  liangshiwei created 3 months ago

  Support Team Fullstack Developer

  Hi,

  You should be able to publish and run the DB migrator in the CI.

  Create multiple environment appsettings files, appsettings.Development.json, appsettings.Production.json etc.

  Save Cancel
• 

  0

  dzungle created 3 months ago

  Hi Liangshiwei,

  Could you please provide more details?

  Here is the appsettings.json in project DbMigrator:

  { "ConnectionStrings": { "Default": "mongodb://localhost:27017/LogiPlat?retryWrites=false", "HangFire": "Data Source=127.0.0.1;Initial Catalog=logi_hangfire;User id=sa;Password=0aP57hal0l39Y1R1GmUoSW;TrustServerCertificate=True;" }, "Redis": { "Configuration": "127.0.0.1" }, "OpenIddict": { "Applications": { "LogiPlat_Web": { "ClientId": "LogiPlat_Web", "ClientSecret": "1q2w3e*", "RootUrl": "https://localhost:44375" }, "LogiPlat_Web_Public": { "ClientId": "LogiPlat_Web_Public", "ClientSecret": "1q2w3e*", "RootUrl": "https://localhost:44377" }, "LogiPlat_Web_Public_Tiered": { "ClientId": "LogiPlat_Web_Public_Tiered", "ClientSecret": "1q2w3e*", "RootUrl": "https://localhost:44316" }, "LogiPlat_App": { "ClientId": "LogiPlat_App", "RootUrl": "http://localhost:4200" }, "LogiPlat_Maui": { "ClientId": "LogiPlat_Maui", "RootUrl": "logiplat://" }, "LogiPlat_Mobile": { "ClientId": "LogiPlat_Mobile", "RootUrl": "exp://localhost:19000" }, "LogiPlat_MauiBlazor": { "ClientId": "LogiPlat_MauiBlazor", "RootUrl": "logiplatmauiblazor://" }, "LogiPlat_BlazorServerTiered": { "ClientId": "LogiPlat_BlazorServerTiered", "ClientSecret": "1q2w3e*", "RootUrl": "https://localhost:44361" }, "LogiPlat_Swagger": { "ClientId": "LogiPlat_Swagger", "RootUrl": "https://localhost:44343" } } } }

  Save Cancel
• 

  0

  liangshiwei created 3 months ago

  Support Team Fullstack Developer

  you can check thishttps://medium.com/abp-community/deploy-your-abp-framework-angular-project-to-azure-kubernetes-service-aks-83fe6bf27d66

  Save Cancel
• 

  0

  dzungle created 3 months ago

  Hi Liangshiwei,

  1. I have successfully connected and updated the remote database from the local development machine. Please, show me how to create and configure multiple environment appsettings files (appsettings.Development.json, appsettings.Production.json) in the DbMigrator project so that I don't have to change the values of OpenIddict Applications when migrating to the remote database.

  2. By the way, I don't see the changes (remove and modify some properties of an entity) applied to the existing documents in MongoDb after running the DbMigrator. Does the DbMigrator (for MongoDb) apply the changes to the existing documents or only apply to the new ones? Or do I have to manually update the changes to the existing documents?

  Thank you

  Save Cancel
• 

  0

  liangshiwei created 3 months ago

  Support Team Fullstack Developer

  Please, show me how to create and configure multiple environment appsettings files (appsettings.Development.json, appsettings.Production.json) in the DbMigrator project so that I don't have to change the values of OpenIddict Applications when migrating to the remote database.

  you just need to create an appsettings.Production.json JSON file. And update the DbMigrator.csproj

    <ItemGroup>
      <None Remove="appsettings.Production.json" />
      <Content Include="appsettings.Production.json">
        <CopyToPublishDirectory>PreserveNewest</CopyToPublishDirectory>
        <CopyToOutputDirectory>Always</CopyToOutputDirectory>
      </Content>
    </ItemGroup>
  

  then you are use then dotnet run --environment Production command

  By the way, I don't see the changes (remove and modify some properties of an entity) applied to the existing documents in MongoDb after running the DbMigrator. Does the DbMigrator (for MongoDb) apply the changes to the existing documents or only apply to the new ones? Or do I have to manually update the changes to the existing documents?

  how do i reproduce this

  Save Cancel