{"id":692,"date":"2009-02-19T19:04:19","date_gmt":"2009-02-19T17:04:19","guid":{"rendered":"http:\/\/www.guion78.com\/wordpress\/?p=692"},"modified":"2010-05-27T18:24:21","modified_gmt":"2010-05-27T16:24:21","slug":"trascodifica-database-relazionali","status":"publish","type":"post","link":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/","title":{"rendered":"Trascodifica \u2013 Database relazionali"},"content":{"rendered":"

Molto spesso si sente parlare di ditte che cambiano gestionale per la tenuta del magazzino (magari piccoli negozi) e passando da un software all\u2019altro tornano a reinserire tutti i dati presenti nel vecchio programma.
\nSe il programma si basa su un database relazionale<\/a> tipo:<\/p>\n

    \n
  1. Mysql<\/li>\n
  2. Sql Server \/ Msde<\/li>\n
  3. Oracle<\/li>\n
  4. Postgress<\/li>\n
  5. Db2 di Ibm<\/li>\n
  6. Access Mdb (anche se non lo considero un database)<\/li>\n
  7. Ingres<\/li>\n
  8. chi pi\u00f9 ne h\u00e0 pi\u00f9 ne metta..<\/li>\n<\/ol>\n

    Beh in tutti questi casi \u00e8 quasi sempre pi\u00f9 semplice procedere ad una trascodifica <\/a>tra una modalit\u00e0 di inserimento dati e l\u2019altro che procedere ad un nuovo reinserimento da zero. Per le trascodifiche alle volte si utilizza un terzo programma ad esempio access per effettuare query di export ed import altre volte si procede ad esportazione dei dati in txt e poi ad una reimportazione ricorretta nel nuovo db. Certo che quasi sempre vale la regola che il lavoro svolto nel tempo per inserire dati non v\u00e0 buttatto in quanto al giorno d\u2019oggi \u00e8 l\u2019informazione\/dato ad avere un valore importantissimo.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Molto spesso si sente parlare di ditte che cambiano gestionale per la tenuta del magazzino (magari piccoli negozi) e passando da un software all\u2019altro tornano a reinserire tutti i dati presenti nel vecchio programma. Se il programma si basa su un database relazionale tipo: Mysql Sql Server \/ Msde Oracle Postgress Db2 di Ibm Access […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"ngg_post_thumbnail":0,"footnotes":""},"categories":[4],"tags":[138,139],"class_list":["post-692","post","type-post","status-publish","format-standard","hentry","category-informazioni","tag-database","tag-trascodifica"],"yoast_head":"\nTrascodifica - Database relazionali - Guion Matteo<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/\" \/>\n<meta property=\"og:locale\" content=\"it_IT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trascodifica - Database relazionali - Guion Matteo\" \/>\n<meta property=\"og:description\" content=\"Molto spesso si sente parlare di ditte che cambiano gestionale per la tenuta del magazzino (magari piccoli negozi) e passando da un software all\u2019altro tornano a reinserire tutti i dati presenti nel vecchio programma. Se il programma si basa su un database relazionale tipo: Mysql Sql Server \/ Msde Oracle Postgress Db2 di Ibm Access […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/\" \/>\n<meta property=\"og:site_name\" content=\"Guion Matteo\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/BlogMatteoGuion\/\" \/>\n<meta property=\"article:published_time\" content=\"2009-02-19T17:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2010-05-27T16:24:21+00:00\" \/>\n<meta name=\"author\" content=\"Gua78\" \/>\n<meta name=\"twitter:label1\" content=\"Scritto da\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gua78\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo di lettura stimato\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/\"},\"author\":{\"name\":\"Gua78\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"headline\":\"Trascodifica \u2013 Database relazionali\",\"datePublished\":\"2009-02-19T17:04:19+00:00\",\"dateModified\":\"2010-05-27T16:24:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/\"},\"wordCount\":173,\"commentCount\":1,\"keywords\":[\"database\",\"trascodifica\"],\"articleSection\":[\"Informazioni\"],\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/\",\"name\":\"Trascodifica - Database relazionali - Guion Matteo\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\"},\"datePublished\":\"2009-02-19T17:04:19+00:00\",\"dateModified\":\"2010-05-27T16:24:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/#breadcrumb\"},\"inLanguage\":\"it-IT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/2009\\\/02\\\/19\\\/trascodifica-database-relazionali\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trascodifica \u2013 Database relazionali\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/\",\"name\":\"Guion Matteo\",\"description\":\"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"it-IT\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/dc866ea65964583c162e5476e0ed60e9\",\"name\":\"Gua78\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"it-IT\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg\",\"caption\":\"Gua78\"},\"description\":\"Amministratore del Portale\",\"sameAs\":[\"http:\\\/\\\/www.guion78.com\"],\"url\":\"https:\\\/\\\/www.guion78.com\\\/wordpress\\\/blog\\\/author\\\/administrator\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Trascodifica - Database relazionali - Guion Matteo","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.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/","og_locale":"it_IT","og_type":"article","og_title":"Trascodifica - Database relazionali - Guion Matteo","og_description":"Molto spesso si sente parlare di ditte che cambiano gestionale per la tenuta del magazzino (magari piccoli negozi) e passando da un software all\u2019altro tornano a reinserire tutti i dati presenti nel vecchio programma. Se il programma si basa su un database relazionale tipo: Mysql Sql Server \/ Msde Oracle Postgress Db2 di Ibm Access […]","og_url":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/","og_site_name":"Guion Matteo","article_publisher":"https:\/\/www.facebook.com\/BlogMatteoGuion\/","article_published_time":"2009-02-19T17:04:19+00:00","article_modified_time":"2010-05-27T16:24:21+00:00","author":"Gua78","twitter_misc":{"Scritto da":"Gua78","Tempo di lettura stimato":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/#article","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/"},"author":{"name":"Gua78","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"headline":"Trascodifica \u2013 Database relazionali","datePublished":"2009-02-19T17:04:19+00:00","dateModified":"2010-05-27T16:24:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/"},"wordCount":173,"commentCount":1,"keywords":["database","trascodifica"],"articleSection":["Informazioni"],"inLanguage":"it-IT","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/","url":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/","name":"Trascodifica - Database relazionali - Guion Matteo","isPartOf":{"@id":"https:\/\/www.guion78.com\/wordpress\/#website"},"datePublished":"2009-02-19T17:04:19+00:00","dateModified":"2010-05-27T16:24:21+00:00","author":{"@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9"},"breadcrumb":{"@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/#breadcrumb"},"inLanguage":"it-IT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.guion78.com\/wordpress\/blog\/2009\/02\/19\/trascodifica-database-relazionali\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.guion78.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Trascodifica \u2013 Database relazionali"}]},{"@type":"WebSite","@id":"https:\/\/www.guion78.com\/wordpress\/#website","url":"https:\/\/www.guion78.com\/wordpress\/","name":"Guion Matteo","description":"Il Blog ? finalizzato a dare una mano nei problemi informatici di tutti i giorni a tutti quelli a cui pu\u00f2 essere utile, spiegato in modo semplice e passo a passo","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.guion78.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"it-IT"},{"@type":"Person","@id":"https:\/\/www.guion78.com\/wordpress\/#\/schema\/person\/dc866ea65964583c162e5476e0ed60e9","name":"Gua78","image":{"@type":"ImageObject","inLanguage":"it-IT","@id":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","url":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4e4699b3c931feae00228b34007799d5331f707aa1cfd35b40d0e0637d82cf18?s=96&d=mm&r=pg","caption":"Gua78"},"description":"Amministratore del Portale","sameAs":["http:\/\/www.guion78.com"],"url":"https:\/\/www.guion78.com\/wordpress\/blog\/author\/administrator\/"}]}},"views":3077,"_links":{"self":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":0,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.guion78.com\/wordpress\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}