NeuCharFramework (NCF)
  • NCF - NeuCharFramework
  • Projects

    • Preparation
    • Basic Library Source Code Analysis
    • DynamicWebApiEngine
    • Deployment
  • Help

    • Online Resources
    • Q&A Community
    • QQ Group (147054579)
    • Senparc WeChat SDK
  • Gitee
  • GitHub
  • English
  • 简体中文
GitHub
  • NCF - NeuCharFramework
  • Projects

    • Preparation
    • Basic Library Source Code Analysis
    • DynamicWebApiEngine
    • Deployment
  • Help

    • Online Resources
    • Q&A Community
    • QQ Group (147054579)
    • Senparc WeChat SDK
  • Gitee
  • GitHub
  • English
  • 简体中文
GitHub
  • NCF Overview

    • NCF - NeuCharFramework
    • About NCF
    • Environment Requirements
    • Frontend and Backend Separation Mode
    • Introduction to Xncf Modules
  • Prepare Development

    • Get NCF Template Source Code
    • Using Visual Studio to Run NCF
    • Running NCF Using CLI
    • Installation
    • Admin Login
    • Admin Backend
    • appsettings.json Configuration
    • Module Management
    • Accessing Documentation
  • Configuration

    • Entry File
    • Database Settings
    • appsettings.json Configuration
    • Docker
    • Dapr
    • Configure Multi-Tenant
    • Redis Cache
  • Modular Development

    • NCF Modular Development Concept
    • Composition of Xncf
    • Create the First Xncf Module
    • Xncf Module Sample Detailed Explanation
    • Implement Your Own Business Logic
    • Update Xncf Module
    • How to Call Between Modules
    • Publish Xncf Module to nuget.org
    • Update Base Library
    • Xncf Module Development
    • Embedding Static Resource Files into NCF
    • Publish Local Nuget Package
    • Advanced
  • Database

    • Database Settings
    • Multi-Database Support
    • Specify Database
    • Update database migration files for the Senparc.Service project (Migrations)
    • Multi-Database Principle
    • DatabasePlant
    • Tarmac Operation Database Migration and Update
  • Unit Testing

    • NCF Unit Test Introduction
    • Start Development
    • Advanced
    • Appendix
  • Q&A

    • NCF Terminology
    • NCF FAQ
  • Release

    • New Features
    • Upgrade Guide
    • Logs

Tarmac Operation Database Migration and Update

Modify Database Configuration File

Modify the Senparc.Web\App_Data\DataBase\SenparcConfig.config file's Local-SqlServer node

<SenparcConfig>
	<Id>3</Id>
	<Name>Local-SqlServer</Name>
	<!--Local Demo default database (can modify DatabaseName configuration in appsettings.json)-->
	<ConnectionStringFull><![CDATA[Server=PC-20210411JFTZ;initial catalog=NCF;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework]]></ConnectionStringFull>
	<!--Use IP within the container-->
	<!--<ConnectionStringFull><![CDATA[Server=172.17.160.1; initial catalog=NCF;User ID=sa; Password=2wsx@WSX;MultipleActiveResultSets=True;App=EntityFramework]]></ConnectionStringFull>-->
	<ApplicationPath><![CDATA[/]]></ApplicationPath>
</SenparcConfig>

Find the configuration file defining the database in your own module Senparc.Xncf.Demo\Senparc.Xncf.Demo.csproj, modify the Local-SqlServer node

<SenparcConfig>
	<Id>2</Id>
	<Name>Local-SqlServer</Name>
	<!--Local Demo default database (can modify DatabaseName configuration in appsettings.json)-->
	<ConnectionStringFull><![CDATA[Server=PC-20210411JFTZ;Database=NCF; initial catalog=NCF;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework]]></ConnectionStringFull>
	<ApplicationPath><![CDATA[/]]></ApplicationPath>
</SenparcConfig>

Find the configuration file defining the database for the tarmac Senparc.Web.DatabasePlant\App_Data\Database\SenparcConfig.config, modify the Local-SqlServer node

<SenparcConfig>
	<Id>2</Id>
	<Name>Local-SqlServer</Name>
	<!--Local Demo default database (can modify DatabaseName configuration in appsettings.json)-->
	<ConnectionStringFull><![CDATA[Server=.\;Database=NCF; initial catalog=NCF;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework]]></ConnectionStringFull>
	<ApplicationPath><![CDATA[/]]></ApplicationPath>
</SenparcConfig>

Original Database Table Structure

Image Text

Tarmac References Modules to be Migrated

Image Text

Use Module Generator's Migration Command

Image Text

Image Text

After generation is complete, it will display

Compare Databases

Image TextImage Text

ImageStatus
Image TextBefore Update
Image TextAfter Update
Edit this page on GitHub
Last Updated:
Contributors: Jeffrey Su
Prev
DatabasePlant