I am trying to migrate DB2 LUW 9.7 databases and data to PostgreSQL 9.3. Any suggestion on which will be the best approach to do it? Which will be the best tool or any open source tool available to perform this?
Migrate DB2 LUW 9.7 databases and data to PostgreSQL
786 Views Asked by Arijit Ghosh At
1
There are 1 best solutions below
Related Questions in DATABASE-MIGRATION
- Django migrations not creating tables on PostgreSQL despite successful execution
- How to specify a float/decimal value for a column inside an insert in liquibase changelog?
- Run the migration script in the container
- Is it possible to downgrade an Entity Framework Core code-first migration without the migration present in the code base?
- ASP.NET Core SQL Server connection - migrations
- Couldn't find driver exception when running php artisan migrate
- SQL Database in production migration - Best approach
- How to setup Flyway migrations for multiple schemas
- mysql to postgres query convertion - COLUMNS.COLUMN_TYPE and information_schema.SEQ_IN_INDEX
- golang-migrate command "freezes" during migrations, takes too much time to migrate (10 minutes for 10 rows)
- Performance Issues After Migrating from MariaDB 10.3.39 to 10.6.16 Due to Changes in Query Execution Plan
- How to generate migration scripts in EF6 with custom SQL?
- Unable to create a 'DbContext' of type ''. The exception 'Unable to resolve service for type 'Microsoft.EntityFrameworkCore.DbContextOptions`1[Comm
- node-pg-migrate not able to run migrations from config defined with .env variables
- django.db.utils.ProgrammingError: column app_table.field does not exist
Related Questions in POSTGRESQL-9.3
- Query to Insert and update records
- Compare fields Where One is Similar to Part of Another in Postgres sql
- Postgres, unable to usedistinct in json_aggr
- Spring R2DBC Compatibility with Postgres
- How do i set role with Supabase?
- how to stop stream clustering on PostgreSQL
- Need help configuring PostgreSQL connection to behave like MySQL: Connect to server without auto-selecting default database
- Postgresql query cast timestamp without time zone adding a second to passed time
- Indicate a schema within an execution format
- XML validation using XSD in postgres procedure
- what is the Proper way to insert json into postgresql table?
- Problem in connection fhirbase to postgres
- pgadmin 4 connection failed Issue. Connection to server at "localhost (::1), port 5432 failed
- pg_basebackup: directory "/u01/edb/as9.6/data/edbdata/syno/DATA/ascii_data" exists but is not empty
- postgres query with calculate before agregate
Related Questions in DB2-LUW
- DB2 a reference to column is ambigous
- Can I dynamically select into an array in DB2?
- How to check active IDs from six months ago
- DB2 - stored procedure - very slow cursor when using IN parameter in fetch first clause
- Automatically unlock tables upon control C
- How to calculate churn Rate (Retention) in db2?
- the relation between agent pool size(num_poolagents) and worker agents and coordinating agents in IBM DB2 (LUW)
- Repeat the Max count of LEAST(DENSE_RANK() OVER (PARTITION BY))
- Difference between TOTAL_CONNECTIONS in MON_GET_INSTANCE and REM_CONS_IN and LOCAL_CONS in SYSIBMADM.SNAPDBM in IBM DB2
- Preserve restrictive flag when restoring Db2 database
- DB2 Distinct Count
- db2 luw - create db hitting error SQL1036C
- AppDynamics - Disable SqlIntegrity Constraint Violation Exception events for a specific DB2 table
- To find out the user has which privileges in db2 database
- DB2 LUW 11.5.9 dbprereqcheck: 'The db2prereqcheck utility failed to find the following package or file: ""'
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The db2look utility can reverse-engineer your DB2 tables into DDL statements that will serve as a good starting point for your PostgreSQL definitions. To unload the data from each table, use the EXPORT command, which dumps the results of any SQL SELECT to a delimited text file. Although the db2move utility can handle both of those tasks, is not going to be of much help to you because it extracts the table data into IBM's proprietary PC/IXF format.
If you're moving off of DB2 because of price, IBM provides a free-as-in-beer version called DB2 Express-C, which shares the same core database engine as paid editions of DB2. Express-C is a first-rate, industrial strength DBMS that does not have the sort of severe limitations that other commercial vendors impose on their no-cost engines.