{"id":3204,"date":"2017-02-05T16:14:39","date_gmt":"2017-02-05T15:14:39","guid":{"rendered":"http:\/\/www.teamvidia.com\/?p=3204"},"modified":"2017-02-05T17:55:27","modified_gmt":"2017-02-05T16:55:27","slug":"banque-de-france","status":"publish","type":"post","link":"https:\/\/www.teamvidia.com\/?p=3204","title":{"rendered":"Banque de France"},"content":{"rendered":"<p><a href=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2871\" src=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\" alt=\"\" width=\"207\" height=\"110\" \/><\/a><\/p>\n<p>Mission de 6 mois Banque De France :(http:\/\/www.banque-france.fr\/accueil.html)<br \/>\nPoc de Migration Oracle 11g vers PostgreSQL 9.4 \u00e0 la Banque de France (Noisiel) sur du Redhat (VmWare)<br \/>\nL'utilisation de l'outil Ora2Pg a permis de migrer une base de 180mo concernant une application de cartographie applicative et une autre application ONEGATE (ONEGATE:Organisat. Nvelle Echanges via Guichet d\u2019Alim. et de Transfert vers l\u2019Ext\u00e9rieur ) dont deux sch\u00e9mas sur une base de 300go (ODG Oracle Data Guard), avec du partitionnement et sous partitionnement et des BLobs. Le bench nominal et aux limites est termin\u00e9 pour carto, analyse en cours des awr Oracle et powa PostgreSQL. Il reste le bench Onegate, une fois l'application compl\u00e8tement 'compatible' PostgreSQL, sans les sp\u00e9cificit\u00e9s Oracle. Le but \u00e9tant de pr\u00e9senter au catalogue une nouvelle offre de base de donn\u00e9es, en plus de Oracle et MSSQL, dont les projets bigdata (versus MongoDB). En pr\u00e9vision , mise en place de PITRERY et l'\u00e9quivalent d'ODG sur Postgres, bascule sur la base r\u00e9pliqu\u00e9e sans reconstruction du master.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mission de 6 mois Banque De France :(http:\/\/www.banque-france.fr\/accueil.html) Poc de Migration Oracle 11g vers PostgreSQL 9.4 \u00e0 la Banque de France (Noisiel) sur du Redhat (VmWare) L'utilisation de l'outil Ora2Pg a permis de migrer une base de 180mo concernant une application de cartographie applicative et une autre application ONEGATE (ONEGATE:Organisat. Nvelle Echanges via Guichet d\u2019Alim. &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[69],"tags":[],"class_list":["post-3204","post","type-post","status-publish","format-standard","hentry","category-clients","no-thumb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\r\n<title>Banque de France - TEAMVIDIA<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/www.teamvidia.com\/?p=3204\" \/>\r\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"Banque de France - TEAMVIDIA\" \/>\r\n<meta property=\"og:description\" content=\"Mission de 6 mois Banque De France :(http:\/\/www.banque-france.fr\/accueil.html) Poc de Migration Oracle 11g vers PostgreSQL 9.4 \u00e0 la Banque de France (Noisiel) sur du Redhat (VmWare) L&#039;utilisation de l&#039;outil Ora2Pg a permis de migrer une base de 180mo concernant une application de cartographie applicative et une autre application ONEGATE (ONEGATE:Organisat. Nvelle Echanges via Guichet d\u2019Alim. &hellip;\" \/>\r\n<meta property=\"og:url\" content=\"https:\/\/www.teamvidia.com\/?p=3204\" \/>\r\n<meta property=\"og:site_name\" content=\"TEAMVIDIA\" \/>\r\n<meta property=\"article:published_time\" content=\"2017-02-05T15:14:39+00:00\" \/>\r\n<meta property=\"article:modified_time\" content=\"2017-02-05T16:55:27+00:00\" \/>\r\n<meta property=\"og:image\" content=\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\" \/>\r\n<meta name=\"author\" content=\"teamvidia\" \/>\r\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"teamvidia\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204\"},\"author\":{\"name\":\"teamvidia\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"headline\":\"Banque de France\",\"datePublished\":\"2017-02-05T15:14:39+00:00\",\"dateModified\":\"2017-02-05T16:55:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204\"},\"wordCount\":182,\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\",\"articleSection\":[\"clients\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204\",\"url\":\"https:\/\/www.teamvidia.com\/?p=3204\",\"name\":\"Banque de France - TEAMVIDIA\",\"isPartOf\":{\"@id\":\"https:\/\/www.teamvidia.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\",\"datePublished\":\"2017-02-05T15:14:39+00:00\",\"dateModified\":\"2017-02-05T16:55:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.teamvidia.com\/?p=3204\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#primaryimage\",\"url\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\",\"contentUrl\":\"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png\",\"width\":207,\"height\":110},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.teamvidia.com\/?p=3204#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.teamvidia.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Banque de France\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.teamvidia.com\/#website\",\"url\":\"https:\/\/www.teamvidia.com\/\",\"name\":\"TEAMVIDIA\",\"description\":\"Experts Base de Donn\u00e9es\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.teamvidia.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96\",\"name\":\"teamvidia\",\"url\":\"https:\/\/www.teamvidia.com\/?author=1\"}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Banque de France - TEAMVIDIA","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamvidia.com\/?p=3204","og_locale":"fr_FR","og_type":"article","og_title":"Banque de France - TEAMVIDIA","og_description":"Mission de 6 mois Banque De France :(http:\/\/www.banque-france.fr\/accueil.html) Poc de Migration Oracle 11g vers PostgreSQL 9.4 \u00e0 la Banque de France (Noisiel) sur du Redhat (VmWare) L'utilisation de l'outil Ora2Pg a permis de migrer une base de 180mo concernant une application de cartographie applicative et une autre application ONEGATE (ONEGATE:Organisat. Nvelle Echanges via Guichet d\u2019Alim. &hellip;","og_url":"https:\/\/www.teamvidia.com\/?p=3204","og_site_name":"TEAMVIDIA","article_published_time":"2017-02-05T15:14:39+00:00","article_modified_time":"2017-02-05T16:55:27+00:00","og_image":[{"url":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png","type":"","width":"","height":""}],"author":"teamvidia","twitter_misc":{"\u00c9crit par":"teamvidia","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamvidia.com\/?p=3204#article","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/?p=3204"},"author":{"name":"teamvidia","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"headline":"Banque de France","datePublished":"2017-02-05T15:14:39+00:00","dateModified":"2017-02-05T16:55:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3204"},"wordCount":182,"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3204#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png","articleSection":["clients"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/www.teamvidia.com\/?p=3204","url":"https:\/\/www.teamvidia.com\/?p=3204","name":"Banque de France - TEAMVIDIA","isPartOf":{"@id":"https:\/\/www.teamvidia.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.teamvidia.com\/?p=3204#primaryimage"},"image":{"@id":"https:\/\/www.teamvidia.com\/?p=3204#primaryimage"},"thumbnailUrl":"http:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png","datePublished":"2017-02-05T15:14:39+00:00","dateModified":"2017-02-05T16:55:27+00:00","author":{"@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96"},"breadcrumb":{"@id":"https:\/\/www.teamvidia.com\/?p=3204#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamvidia.com\/?p=3204"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.teamvidia.com\/?p=3204#primaryimage","url":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png","contentUrl":"https:\/\/www.teamvidia.com\/wp-content\/uploads\/2015\/07\/logo_bdf.png","width":207,"height":110},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamvidia.com\/?p=3204#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.teamvidia.com\/"},{"@type":"ListItem","position":2,"name":"Banque de France"}]},{"@type":"WebSite","@id":"https:\/\/www.teamvidia.com\/#website","url":"https:\/\/www.teamvidia.com\/","name":"TEAMVIDIA","description":"Experts Base de Donn\u00e9es","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamvidia.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/www.teamvidia.com\/#\/schema\/person\/9ac7fc1a993573d0d3f267bff5361f96","name":"teamvidia","url":"https:\/\/www.teamvidia.com\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3204"}],"version-history":[{"count":2,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3204\/revisions"}],"predecessor-version":[{"id":3218,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=\/wp\/v2\/posts\/3204\/revisions\/3218"}],"wp:attachment":[{"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3204"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3204"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamvidia.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}