How to migrate database data in production?

• TypeORM

  156 33,307 9.0 TypeScript

  ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

  

Definitely you should use migrations or a schema diffing tool. Usually schema migration is a feature offered by many ORMs e.g. https://github.com/typeorm/typeorm/blob/master/docs/migrations.md You can also handle migrations with a dedicated SQL only tool like migrate https://github.com/golang-migrate/migrate. Or, as a schema diffing tool, afaik the best one is the one from pgadmin https://www.pgadmin.org/docs/pgadmin4/development/schema_diff.html#:~:text=Schema%20Diff%20is%20a%20feature,(from%20source%20to%20target).

• migrate

  72 14,000 8.0 Go

  Database migrations. CLI and Golang library.

  

Definitely you should use migrations or a schema diffing tool. Usually schema migration is a feature offered by many ORMs e.g. https://github.com/typeorm/typeorm/blob/master/docs/migrations.md You can also handle migrations with a dedicated SQL only tool like migrate https://github.com/golang-migrate/migrate. Or, as a schema diffing tool, afaik the best one is the one from pgadmin https://www.pgadmin.org/docs/pgadmin4/development/schema_diff.html#:~:text=Schema%20Diff%20is%20a%20feature,(from%20source%20to%20target).

• SurveyJS

  surveyjs.io featured

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

Suggest a related project