â â ãããããã¨Â â â PostgreSQLããRedshiftã®ãã¼ãã«ãåç §ãããã æ¹æ³ã¨ãã¦ã¯ãDBLINKã¨postgres_fdwã¨ããã®ããããããã â DBLINK ããPostgreSQLãããå¥ã®PostgreSQLã«ã¢ã¯ã»ã¹ã§ããã PostgreSQLæ¨æºã®æ©è½ã ãªã¢ã¼ãDBãæã¤ãã¼ãã«ã«ãã¼ã«ã«ã©ã¤ã¯ã«ã¢ã¯ã»ã¹ã§ãããã ã»ãªã¢ã¼ã表ãSELECTããå ´åããã¼ã¿ãå ¨ä»¶ãã¼ã«ã«ã«æã£ã¦ãããããã¼ã¿è»¢éãå¤ããªãã ã»ãªã¢ã¼ãDBã®ãã¼ãã«ãè¡ãããã¯ããªããæ´åæ§ãæ ä¿ããããã«ã¯äºç¸ã³ãããã®å®è£ ãå¿ è¦ã ã»ç¬ç¹ãªSQLæ¸å¼ ãªã©ãå¶ç´ã¯ããã â postgres_fdw DBLINKã®å¾ç¶æ©è½ã ã¯ã¨ãªã¯ãªã¼ã½ããã¯ã¹ãªæ¸å¼ã§éç¨ããããçµåãã½ã¼ãã LIMITãéç´ãªã©ããªã¢ã¼ãã§ã¯ãªããã¼ã«ã«ã§è¡ãããã ï¼WHEREå¥ã«ããã·ã³ãã«ãªçµãè¾¼
SqlSync ã§ã¯2ã¤ã®ãã¼ã¿ãã¼ã¹ãæ¯è¼ãã¦ãã©ã®ã¿ãã«ã追å ãããé¤ãããå¤æ´ãããããç¥ããã¨ãã§ãããã¾ããä¸æ¹ã®ãã¼ã¿ãã¼ã¹ãä»æ¹ã®ã¯ãã¼ã³ã«ããå¿ è¦ãªå¤æ´ãå ããªãããã®ç¶æ ãä¿ã¤ãã¨ãã§ãããåæåã«SqlSyncãç¨ãããã¨ã«ã¯ãç°ç¨®ã¨ã³ã¸ã³éï¼ãã¨ãã°ãMySQLããPostgreSQLã¸ï¼ã®åæåãã§ããã¨ããã¡ãªãããããã UbuntuãFedoraãopenSUSEã®æ¨æºãªãã¸ããªã«ã¯SqlSyncããã±ã¼ã¸ããªããããã§ãæ¬ç¨¿ã§ã¯ãã¼ã¸ã§ã³1.0.0-rc1ã使ãã64ãããã®Fedora 8ãã·ã³ã§ã½ã¼ã¹ãããã«ããããã¨ã«ãããããã¸ã§ã¯ãã®freshmeatãã¼ã¸ã«ããã¼ã ãã¼ã¸ã«ãæ¸ããã¦ããªãããSqlSyncã¯ãã¼ã¿ãã¼ã¹ã¸ã®ã¢ã¯ã»ã¹ã«ODBCã使ãããããã£ã¦ãunixODBCéçºããã±ã¼ã¸ãã¤ã³ã¹ãã¼ã«ããã¦ããªãã¨ããã«ãã¯æåããªãã Sq
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}