Breaking News: Grepper is joining You.com. Read the official announcement!

migrate sql

Innocent Iguana answered on February 18, 2023 Popularity 8/10 Helpfulness 4/10

answer migrate sql

related migrate sql

migrate sql

Comment

Use simple approach:
1. Export tables as csv files in mysql
2. Import the csv files as tables in postgresql
Con : Re-establish relationships between tables in new environment

Note: Since there might be multiple multiple tables, create a procedure
to do this repeatitive task.

Alternative approach:
- Use "db-migrate"
Con : Write long migration script for each table (too much hassle)

Popularity 8/10 Helpfulness 4/10 Language whatever

Source: Grepper

Tags: migrate sql

Link to this answer
Share Copy Link

Contributed on Feb 18 2023

Innocent Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

migrate sql

Comment

# Install package
npm install -g db-migrate

# Install drivers for specific DBMS
npm install -g db-migrate-mysql # Mysql
npm install -g db-migrate-postgresql # PostgreSQL
npm install -g db-migrate-sqlserver # SQL Server

# Generate migration file the database you are migrating from
db-migrate create mysql-to-sqlserver --migrations-dir=migrations -e mysql
db-migrate create mysql-to-postgresql --migrations-dir=migrations -e mysql
db-migrate create sqlserver-to-mysql --migrations-dir=migrations -e sqlserver

# Edit migration file (Same for all)
'use strict';

var dbm = global.dbm || require('db-migrate');
var type = dbm.dataType;

exports.up = function(db, callback) {
  db.createTable('table_name', {
    id: { type: 'int', primaryKey: true, autoIncrement: true },
    col1: { type: 'string', unique: true },
    col2: { type: 'float' }
  }, callback);
};

exports.down = function(db, callback) {
  db.dropTable('table_name', callback);
};

# Run command for destination Environment
db-migrate up --config database.json --env mysql # Destination is MySQL
db-migrate up --config database.json --env sqlserver # Destination is SQL Server
db-migrate up --config database.json --env postgresql # Destination is PostgreSQL

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: sql migrate

Link to this answer
Share Copy Link

Contributed on Feb 18 2023

Innocent Iguana

0 Answers Avg Quality 2/10

migrate sql

Contents

More Related Answers

migrate sql

Closely Related Answers

migrate sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.