{"id":2823,"date":"2020-07-09T00:40:23","date_gmt":"2020-07-09T05:40:23","guid":{"rendered":"http:\/\/linuxitos.com\/main\/?p=2823"},"modified":"2020-07-09T00:40:24","modified_gmt":"2020-07-09T05:40:24","slug":"instalar-sql-server-docker-fedora-32","status":"publish","type":"post","link":"https:\/\/linuxitos.com\/main\/instalar-sql-server-docker-fedora-32\/","title":{"rendered":"Instalar SQL Server Docker | Fedora 32"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"822\" height=\"467\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/06\/download.png\" alt=\"\" class=\"wp-image-2803\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/06\/download.png 822w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/06\/download-300x170.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/06\/download-768x436.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Inicio<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">En algunos casos es necesario usar sql server, ya sea para pruebas de desarrollo o incluso para producci\u00f3n. Docker es una excelente opci\u00f3n cuando no se cuenta o no se quiere instalar todo el entorno de windows para poderlo utilizar.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL Server en Docker<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">La idea es instalarlo en Fedora, y utilizar con un cliente como dbeaver, el cual es un gestor de consultas.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">La instalaci\u00f3n en docker para fedora es el siguiente m\u00e9todo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">sudo docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=73jIUYj-Strong(!)Password' -p 1433:1433 -d mcr.microsoft.com\/mssql\/server:2017-CU8-ubuntu\n\n#  SA_PASSWORD: Es la contrase\u00f1a para el usuario sa del servidor, el cual se usar\u00e1 para acceder desde el cliente dbevaer.\n# -p: es el puerto\n# -d: es la ruta de la imagen a descargar<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Ese comando instalar\u00e1 una imagen de ubuntu con sql server versi\u00f3n 2017.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">En \u00e9ste link podr\u00e1n consultar las versiones que hay, o si quieren modificar algo:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/hub.docker.com\/_\/microsoft-mssql-server\">https:\/\/hub.docker.com\/_\/microsoft-mssql-server<\/a> Ah\u00ed encontrar\u00e1n las posibles opciones, versiones, o configuraciones.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Accediendo desde dbeaver<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Crear la conexi\u00f3n con los par\u00e1metros que se establecieron en la creaci\u00f3n:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"647\" height=\"657\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-33.png\" alt=\"\" class=\"wp-image-2824\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-33.png 647w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-33-295x300.png 295w\" sizes=\"auto, (max-width: 647px) 100vw, 647px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"705\" height=\"701\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-41.png\" alt=\"\" class=\"wp-image-2825\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-41.png 705w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-41-300x298.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-33-41-150x150.png 150w\" sizes=\"auto, (max-width: 705px) 100vw, 705px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Visualizando los datos:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"540\" src=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-37-58-1024x540.png\" alt=\"\" class=\"wp-image-2826\" srcset=\"https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-37-58-1024x540.png 1024w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-37-58-300x158.png 300w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-37-58-768x405.png 768w, https:\/\/linuxitos.com\/main\/wp-content\/uploads\/2020\/07\/Screenshot-from-2020-07-09-00-37-58.png 1454w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Y con eso se tiene una instalaci\u00f3n de sql server en docker, claro, a \u00e9sto hay que configurarlo para que los datos sean persistentes, y accesibles en todo momento.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Inicio En algunos casos es necesario usar sql server, ya sea para pruebas de desarrollo o incluso para producci\u00f3n. Docker es una excelente opci\u00f3n cuando no se cuenta o no se quiere instalar todo el entorno de windows para poderlo utilizar. SQL Server en Docker La idea es instalarlo en Fedora, y utilizar con un [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1511],"tags":[1694,1561,1695],"class_list":["post-2823","post","type-post","status-publish","format-standard","hentry","category-server","tag-docker","tag-fedora","tag-sql-server"],"_links":{"self":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/comments?post=2823"}],"version-history":[{"count":1,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2823\/revisions"}],"predecessor-version":[{"id":2827,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/posts\/2823\/revisions\/2827"}],"wp:attachment":[{"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/media?parent=2823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/categories?post=2823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxitos.com\/main\/wp-json\/wp\/v2\/tags?post=2823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}