Oracle to SQL Server and SQL Server to Oracle Migration Guide

In this blog, I shared some link  which will helpful to understand and implement these migration.

Thanks to all author those share knowledge.


Links :- 

https://www.toptal.com/sql/oracle-sql-server-differences
https://www.toptal.com/sql/oracle-sql-server-migrations-pt-2
https://www.toptal.com/sql/oracle-sql-server-migrations-pt-3

Database Migration

For any database migration we should follow below practices.

1. Evaluate Complexity of Data

2. Establish Data Standards

3. Define Current and Future Business Rules

4. Establish Information Governance Roles and Responsibilities

5. Perform Data Quality Assessment

6. Gather Migration Requirements

7. Assess and Identify the Proper Tool

8. Risk Management

9. Organizational Changes

10. Migration Testing

Some Different Database Migration Link : -

 

Migrate Oracle Database to PostgreSQL

https://aws.amazon.com/blogs/database/how-to-migrate-your-oracle-database-to-postgresql/

https://www.postgresql.org/about/news/1459/

https://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion

https://www.convert-in.com/docs/ora2pgs/intro.htm

SQL Server database migration best practices for low risk and downtime

https://www.sqlshack.com/sql-server-database-migration-best-practices-low-risk-downtime/

Data Migration Best Practices

http://www.consultparagon.com/blog/10-data-migration-best-practices-for-any-organization

http://www.dataversity.net/five-data-migration-best-practices-ensure-successful-move/

https://www.cygnet-infotech.com/blog/9-best-practices-for-successful-data-migration-projects

https://www.outsource2india.com/DataManagement/articles/data-migration-best-practices.asp

https://www.lbmctech.com/webfiles/Top_10_Best_Practices_for_Migrating_Data_from_On-premise_to_the_Cloud.pdf

https://dzone.com/articles/safe-database-migration-pattern-without-downtime

Migrate Oracle Database to MySql

https://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/

                                                                                                                                                                                                                  

Migrate PostgreSQL to MySQL using the MySQL Workbench Migration Wizard

https://mysqlworkbench.org/2012/11/how-to-migrate-postgresql-databases-to-mysql-using-the-mysql-workbench-migration-wizard/comment-page-1/

MySQL to PostgreSQL Migration 

https://www.endpoint.com/blog/2014/11/26/mysql-to-postgresql-migration-tips