Read Time2 Second
Description | Link |
---|---|
Original Article on The Developer Space | http://thedeveloperspace.com/migrating-your-sql-server-workloads-to-postgresql/ |
EnterpriseDB Home | https://www.enterprisedb.com |
DB-Engines Ranking | https://db-engines.com/en/ranking |
Microsoft SQL Server Home | https://www.microsoft.com/en-in/sql-server |
SQL Server Wikipedia | https://en.wikipedia.org/wiki/Microsoft_SQL_Server |
DB-Engines SQL Server Page | https://db-engines.com/en/system/Microsoft+SQL+Server |
PostgreSQL Home | https://www.postgresql.org |
PostgreSQL Wikipedia | https://en.wikipedia.org/wiki/PostgreSQL |
DB-Engines PostgreSQL Page | https://db-engines.com/en/system/PostgreSQL |
PostgreSQL Feature Matrix | https://www.postgresql.org/about/featurematrix |
DB-Engines SQL Server vs PostgreSQL | https://db-engines.com/en/system/Microsoft+SQL+Server%3BPostgreSQL |
SQL Server - Locking and Row Versioning | https://.microsoft.com/en-us/library/ms187101.aspx |
SQL Server 2017 Maximum Capacity Specifications | https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-2017&viewFallbackFrom=sql-server-previousversions |
SQL Server 2014 Maximum Capacity Specifications | https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-2014 |
PostgreSQL Data Types | https://www.tutorialspoint.com/postgresql/postgresql_data_types.htm |
PostgreSQL Functions | https://www.postgresql.org/docs/11/functions.html |
PostgreSQL AutoVacuum | https://www.postgresql.org/docs/11/runtime-config-autovacuum.html |
RDS AutoVacuum Case Study | https://aws.amazon.com/blogs/database/a-case-study-of-tuning-autovacuum-in-amazon-rds-for-postgresql |
PostgreSQL Vacuum | https://www.postgresql.org/docs/11/sql-vacuum.html |
TCL Language | http://www.tcl.tk |
PostgreSQL Generated Columns | http://thedeveloperspace.com/generated-columns-in-postgresql/ |
pgLoader | https://github.com/dimitri/pgloader |
Sqlserver2pgsql | https://github.com/dalibo/sqlserver2pgsql |
Talend Open Studio | https://www.talend.com/products/data-integration/data-integration-open-studio |
Pentaho Data Integration | https://www.hitachivantara.com/en-in/products/big-data-integration-analytics/pentaho-data-integration.html |
Jasper Reports | https://community.jaspersoft.com/project/jasperreports-server |
BIRT | http://www.eclipse.org/birt |
Pentaho Reporting | https://community.hitachivantara.com/s/article/pentaho-reporting |
Pentaho Mondrian | https://community.hitachivantara.com/s/article/mondrian |
Apache Kylin | http://kylin.apache.org |
pgAgent | https://www.pgadmin.org/docs/pgadmin4/development/pgagent.html |
AWS Job Scheduler | https://docs.aws.amazon.com/batch/latest/userguide/job_scheduling.html |
PostgreSQL Java Drivers | https://jdbc.postgresql.org/ |
Npgsql | https://www.npgsql.org/ |
PostgreSQL Drivers & Interfaces | https://www.postgresql.org/download/products/2-drivers-and-interfaces/ |
PostgreSQL Monitoring | https://wiki.postgresql.org/wiki/Monitoring |
Replication, Clustering, and Connection Pooling | https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling |
High Availability, Load Balancing, and Replication | https://www.postgresql.org/docs/current/high-availability.html |
PostgreSQL Replication Solutions (pdf) | http://momjian.us/main/writings/pgsql/replication.pdf |