{"id":5456,"date":"2025-12-20T11:21:10","date_gmt":"2025-12-20T19:21:10","guid":{"rendered":"https:\/\/cwinsystems.com\/inicio\/?p=5456"},"modified":"2025-12-20T11:21:53","modified_gmt":"2025-12-20T19:21:53","slug":"instalacion-de-firebird","status":"publish","type":"post","link":"https:\/\/cwinsystems.com\/inicio\/capacitacion\/instalacion-de-firebird\/","title":{"rendered":"Instalaci\u00f3n de Firebird"},"content":{"rendered":"<div id=\"model-response-message-contentr_d3c15f40ede0e557\" class=\"markdown markdown-main-panel stronger enable-updated-hr-color\" dir=\"ltr\" aria-live=\"off\" aria-busy=\"false\">\n<p data-path-to-node=\"0\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-5457\" src=\"https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-1024x559.png\" alt=\"\" width=\"604\" height=\"330\" srcset=\"https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-1024x559.png 1024w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-300x164.png 300w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-768x419.png 768w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-1536x838.png 1536w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-2048x1117.png 2048w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-24x13.png 24w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-36x20.png 36w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-48x26.png 48w, https:\/\/cwinsystems.com\/inicio\/wp-content\/uploads\/2025\/12\/Gemini_Generated_Image_f5y5e6f5y5e6f5y5-600x327.png 600w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<h3 id='resumen-general'  id=\"boomdevs_1\" data-path-to-node=\"1\"><b data-path-to-node=\"1\" data-index-in-node=\"0\">Resumen General<\/b><\/h3>\n<p data-path-to-node=\"2\">Este video es un tutorial t\u00e9cnico avanzado que explica el proceso de migraci\u00f3n y actualizaci\u00f3n del motor de base de datos <b data-path-to-node=\"2\" data-index-in-node=\"122\">Firebird<\/b> utilizado por el sistema DisPRO. A partir de la versi\u00f3n 2024, DisPRO permite usar versiones m\u00e1s modernas de Firebird (2.5.9, 3.0, 4.0, 5.0) en lugar de la cl\u00e1sica 2.1. El video cubre dos escenarios principales:<\/p>\n<ol start=\"1\" data-path-to-node=\"3\">\n<li>\n<p data-path-to-node=\"3,0,0\"><b data-path-to-node=\"3,0,0\" data-index-in-node=\"0\">Actualizaci\u00f3n Est\u00e1ndar (Recomendada):<\/b> Pasar de Firebird 2.1 a 2.5.9 usando los instaladores incluidos en DisPRO.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"3,1,0\"><b data-path-to-node=\"3,1,0\" data-index-in-node=\"0\">Migraci\u00f3n Avanzada (Manual):<\/b> Pasar a Firebird 5.0, lo cual requiere respaldar y restaurar la base de datos debido a cambios de estructura, adem\u00e1s de configuraciones manuales de librer\u00edas.<\/p>\n<\/li>\n<\/ol>\n<h3 id='puntos-clave-y-procedimientos'  id=\"boomdevs_2\" data-path-to-node=\"4\"><b data-path-to-node=\"4\" data-index-in-node=\"0\">Puntos Clave y Procedimientos<\/b><\/h3>\n<p data-path-to-node=\"5\"><b data-path-to-node=\"5\" data-index-in-node=\"0\">1. Actualizaci\u00f3n a Firebird 2.5.9 (Proceso Sencillo)<\/b><\/p>\n<ul data-path-to-node=\"6\">\n<li>\n<p data-path-to-node=\"6,0,0\"><b data-path-to-node=\"6,0,0\" data-index-in-node=\"0\">Compatibilidad:<\/b> Esta versi\u00f3n es muy estable y compatible con Windows 11. El cambio de estructura de base de datos es m\u00ednimo o nulo.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,1,0\"><b data-path-to-node=\"6,1,0\" data-index-in-node=\"0\">Pasos:<\/b><\/p>\n<ol start=\"1\" data-path-to-node=\"6,1,1\">\n<li>\n<p data-path-to-node=\"6,1,1,0,0\">Desinstalar Firebird 2.1 completamente (borrar carpeta de instalaci\u00f3n).<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,1,1,1,0\">Ejecutar el instalador de Firebird 2.5.9 ubicado en la carpeta <code data-path-to-node=\"6,1,1,1,0\" data-index-in-node=\"63\">redist<\/code> de DisPRO [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=186\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ7AQ\">03:06<\/a>].<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,1,1,2,0\">Seleccionar \"Classic Server\" para instalaciones en red.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"6,1,1,3,0\"><b data-path-to-node=\"6,1,1,3,0\" data-index-in-node=\"0\">Paso Cr\u00edtico:<\/b> Copiar el archivo <code data-path-to-node=\"6,1,1,3,0\" data-index-in-node=\"32\">udf_cwin.dll<\/code> (ubicado en <code data-path-to-node=\"6,1,1,3,0\" data-index-in-node=\"57\">redist<\/code>) y pegarlo en la carpeta <code data-path-to-node=\"6,1,1,3,0\" data-index-in-node=\"89\">C:\\Program Files\\Firebird\\Firebird_2_5\\UDF<\/code> [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=256\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ7QQ\">04:16<\/a>]. Sin esto, DisPRO no funcionar\u00e1.<\/p>\n<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p data-path-to-node=\"7\"><b data-path-to-node=\"7\" data-index-in-node=\"0\">2. Migraci\u00f3n a Firebird 5.0 (Proceso Avanzado)<\/b><\/p>\n<ul data-path-to-node=\"8\">\n<li>\n<p data-path-to-node=\"8,0,0\"><b data-path-to-node=\"8,0,0\" data-index-in-node=\"0\">Incompatibilidad Directa:<\/b> Las bases de datos de versiones antiguas (2.1) no abren directamente en la versi\u00f3n 5.0. Requieren un proceso de \"Backup y Restore\" para convertir la estructura.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,1,0\"><b data-path-to-node=\"8,1,0\" data-index-in-node=\"0\">Pasos Previos:<\/b><\/p>\n<ol start=\"1\" data-path-to-node=\"8,1,1\">\n<li>\n<p data-path-to-node=\"8,1,1,0,0\">Hacer un respaldo (Backup) de la empresa <i data-path-to-node=\"8,1,1,0,0\" data-index-in-node=\"41\">antes<\/i> de desinstalar la versi\u00f3n vieja [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=401\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ7gQ\">06:41<\/a>].<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,1,1,1,0\">Desinstalar la versi\u00f3n anterior de Firebird.<\/p>\n<\/li>\n<\/ol>\n<\/li>\n<li>\n<p data-path-to-node=\"8,2,0\"><b data-path-to-node=\"8,2,0\" data-index-in-node=\"0\">Instalaci\u00f3n Manual:<\/b><\/p>\n<ol start=\"1\" data-path-to-node=\"8,2,1\">\n<li>\n<p data-path-to-node=\"8,2,1,0,0\">Descargar el instalador de Firebird 5.0 (32 bits) desde la web oficial.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,2,1,1,0\">Elegir arquitectura: \"Classic Server\" o \"Super Classic\" (el video explica las diferencias de gesti\u00f3n de cach\u00e9 y procesos) [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=649\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ7wQ\">10:49<\/a>].<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,2,1,2,0\">Activar la casilla <b data-path-to-node=\"8,2,1,2,0\" data-index-in-node=\"19\">\"Copy Firebird client library to &lt;system&gt; directory\"<\/b>; es vital para la conexi\u00f3n [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=753\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ8AQ\">12:33<\/a>].<\/p>\n<\/li>\n<\/ol>\n<\/li>\n<li>\n<p data-path-to-node=\"8,3,0\"><b data-path-to-node=\"8,3,0\" data-index-in-node=\"0\">Configuraci\u00f3n UDF (M\u00e1s compleja en v5.0):<\/b><\/p>\n<ol start=\"1\" data-path-to-node=\"8,3,1\">\n<li>\n<p data-path-to-node=\"8,3,1,0,0\">Crear manualmente la carpeta <code data-path-to-node=\"8,3,1,0,0\" data-index-in-node=\"29\">UDF<\/code> en el directorio de instalaci\u00f3n de Firebird 5.0.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,3,1,1,0\">Copiar el DLL de CWin Systems ah\u00ed.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"8,3,1,2,0\">Editar el archivo <code data-path-to-node=\"8,3,1,2,0\" data-index-in-node=\"18\">firebird.conf<\/code>: Buscar el par\u00e1metro <code data-path-to-node=\"8,3,1,2,0\" data-index-in-node=\"53\">UdfAccess<\/code>, quitar el comentario (#) y poner la ruta completa de la carpeta UDF con permiso <code data-path-to-node=\"8,3,1,2,0\" data-index-in-node=\"144\">Restrict<\/code> [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=861\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ8QQ\">14:21<\/a>].<\/p>\n<\/li>\n<\/ol>\n<\/li>\n<li>\n<p data-path-to-node=\"8,4,0\"><b data-path-to-node=\"8,4,0\" data-index-in-node=\"0\">Restauraci\u00f3n:<\/b> Usar la herramienta de restauraci\u00f3n de DisPRO para cargar el respaldo antiguo. Al restaurarse en el nuevo motor, la base de datos se convierte autom\u00e1ticamente al formato ODS 13 (Firebird 5.0) y ya ser\u00e1 accesible [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=963\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ8gQ\">16:03<\/a>].<\/p>\n<\/li>\n<\/ul>\n<p data-path-to-node=\"9\"><b data-path-to-node=\"9\" data-index-in-node=\"0\">3. Actualizaci\u00f3n de Clientes<\/b><\/p>\n<ul data-path-to-node=\"10\">\n<li>\n<p data-path-to-node=\"10,0,0\">Es obligatorio que <b data-path-to-node=\"10,0,0\" data-index-in-node=\"19\">todas<\/b> las computadoras clientes en la red tengan instalada la <b data-path-to-node=\"10,0,0\" data-index-in-node=\"81\">misma versi\u00f3n del cliente Firebird<\/b> que el servidor (si el servidor tiene la 5.0, los clientes deben tener el cliente 5.0) [<a class=\"ng-star-inserted\" href=\"http:\/\/www.youtube.com\/watch?v=W7przc9GKzA&amp;t=1132\" target=\"_blank\" rel=\"noopener\" data-hveid=\"0\" data-ved=\"0CAAQ_4QMahgKEwi806KV4MyRAxUAAAAAHQAAAAAQ8wQ\">18:52<\/a>].<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"10,1,0\">En los clientes, se debe instalar eligiendo solo los componentes de conectividad (desmarcar \"Server components\") y asegur\u00e1ndose de copiar la librer\u00eda <code data-path-to-node=\"10,1,0\" data-index-in-node=\"150\">gds32.dll<\/code> al sistema.<\/p>\n<\/li>\n<\/ul>\n<h3 id='an\u00e1lisis-de-utilidad'  id=\"boomdevs_3\" data-path-to-node=\"11\"><b data-path-to-node=\"11\" data-index-in-node=\"0\">An\u00e1lisis de Utilidad<\/b><\/h3>\n<p data-path-to-node=\"12\">Este tutorial es esencial para administradores que buscan mejorar el rendimiento:<\/p>\n<ul data-path-to-node=\"13\">\n<li style=\"list-style-type: none;\">\n<ul data-path-to-node=\"13\">\n<li>\n<p data-path-to-node=\"13,0,0\"><b data-path-to-node=\"13,0,0\" data-index-in-node=\"0\">Mejora de Velocidad:<\/b> Las nuevas versiones de Firebird (especialmente la 3.0 en adelante) gestionan mucho mejor los procesos en CPUs modernos y redes complejas.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"13,1,0\"><b data-path-to-node=\"13,1,0\" data-index-in-node=\"0\">Estabilidad en Windows 11:<\/b> Resuelve problemas de compatibilidad que la vieja versi\u00f3n 2.1 empezaba a mostrar.<\/p>\n<\/li>\n<li>\n<p data-path-to-node=\"13,2,0\"><b data-path-to-node=\"13,2,0\" data-index-in-node=\"0\">Precauci\u00f3n:<\/b> Advierte claramente que migrar a la versi\u00f3n 5.0 no es un simple \"siguiente, siguiente\", sino que requiere manipulaci\u00f3n de archivos de configuraci\u00f3n y conversi\u00f3n de datos, evitando desastres de \"base de datos corrupta\" por intentar abrir archivos viejos con el motor nuevo.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div class=\"attachment-container youtube\"><\/div>\n<\/div>\n<p><iframe loading=\"lazy\" title=\"Instalacio\u0301n de Firebird\" width=\"604\" height=\"340\" src=\"https:\/\/www.youtube.com\/embed\/W7przc9GKzA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Resumen General Este video es un tutorial t\u00e9cnico avanzado que explica el proceso de migraci\u00f3n y actualizaci\u00f3n del motor de base de datos Firebird utilizado por el sistema DisPRO. A partir de la versi\u00f3n 2024, DisPRO permite usar versiones m\u00e1s modernas de Firebird (2.5.9, 3.0, 4.0, 5.0) en lugar de la cl\u00e1sica 2.1. El video cubre dos escenarios principales: Actualizaci\u00f3n&nbsp;<a href=\"https:\/\/cwinsystems.com\/inicio\/capacitacion\/instalacion-de-firebird\/\" class=\"read-more\">Continue Reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":5457,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[],"class_list":["post-5456","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-capacitacion","cat-79-id"],"_links":{"self":[{"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/posts\/5456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/comments?post=5456"}],"version-history":[{"count":1,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/posts\/5456\/revisions"}],"predecessor-version":[{"id":5458,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/posts\/5456\/revisions\/5458"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/media\/5457"}],"wp:attachment":[{"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/media?parent=5456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/categories?post=5456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cwinsystems.com\/inicio\/wp-json\/wp\/v2\/tags?post=5456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}