{"repo":"isapir/Migrate2Postgres","free":true,"listed":false,"github":"https://github.com/isapir/Migrate2Postgres","clone":"git clone https://github.com/isapir/Migrate2Postgres.git","description":"Easily migrate from other DBMSs to PostgreSQL","language":"Java","stars":53,"topics":["postgresql","postgres","migration","migration-tool","migrate-database"],"license":"GPL-3.0","category":"databases-storage","readme_excerpt":"Migrate2Postgres This tool allows you to easily migrate databases from other JDBC-compliant DBMSs to Postgres. The project is written in Java, so it is cross-platform and can run on any operating system that has a Java SE Runtime version 1.8 or later. Currently the project ships with a template for SQL Server as a source, but other source database systems can be added easily by following the same patterns that are documented in the SQL Server template and the example config files. Requirements - Java Runtime Environment (JRE) 1.8 or later - JDBC Drivers for the DBMSs used Getting Started Create a config file -- The config file is a JSON file that contains the information needed for the migration. It can be a standalone file, or inherit from a template by specifying the template key where the value is a valid template, e.g. ms-sql-server. That information includes the connection details for the source and target databases, mappings of SQL types for the DDL phase (e.g. SQL Server's NVARCHAR to Postgres' TEXT ), mappings of JDBC types for the DML phase, name transformations (e.g. SomeTableName to some table name ), queries to run before (e.g. disable triggers) and after (e.g. re-enable triggers or REFRESH MATERIALIZED VIEWS ) the DML process, number of concurrent threads, and more. The \"effective\" configuration values are applied in the following manner: 1) The defaults are read from defaults.conf 2) If the config file has a key named template , then the template specified in th","default_branch":null,"files":null,"tree":[],"storefront":"/r/isapir","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/isapir/Migrate2Postgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}