[{"_1":2,"_169":-5,"_170":-5},"loaderData",{"_3":4,"_13":14,"_21":22,"_144":145},"root",{"_5":-5,"_6":-7,"_7":8,"_9":-7,"_10":11,"_12":-7},"currentUser","primaryEmail","siteVerification","6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI","toast","enableDev",false,"incidentStatus","routes/_layout",{"_15":-5,"_16":17,"_18":17,"_19":11,"_20":17},"username","isAskGordonEnabled",true,"isUsingNewTemplate","showMinimalLanding","showHoneypotTrap","routes/_layout.r.$namespace.$reponame",{"_23":24,"_25":-5,"_26":11,"_27":11,"_28":29,"_30":31,"_32":-5,"_33":11,"_34":35,"_84":-5,"_85":86,"_135":-5,"_136":11,"_137":17,"_138":11,"_139":-5,"_140":11,"_141":-5,"_142":143},"canonicalUrl","https://hub.docker.com/r/mihalby/sqlscm/tags","mcpServer","canSeeDockerfile","canSeeAutobuilds","namespace","mihalby","reponame","sqlscm","cloudBuildSource","isAutobuildsAvailable","repo",{"_36":37,"_38":39,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":51,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":70,"_75":11,"_76":77,"_81":29,"_82":83},"categories",[],"content_types",[40],"image","date_registered","2019-01-01T19:14:33.097308Z","description","Source control for programmings objects of ms sql ","is_private","last_updated","2020-03-28T13:04:09.834401Z","last_modified","2024-10-16T13:48:34.145251Z","media_types",[52],"application/vnd.docker.container.image.v1+json","name","pull_count",1031,"repository_type","star_count",0,"status",1,"status_description","active","source","collaborator_count","full_description","[![Build Status](https://travis-ci.com/mihalby/sqlscm.svg?branch=master)](https://travis-ci.com/mihalby/sqlscm)\n[![Docker Build](https://img.shields.io/docker/automated/mihalby/sqlscm.svg)](https://hub.docker.com/r/mihalby/sqlscm)\n[![Docker Pulls](https://img.shields.io/docker/pulls/mihalby/sqlscm.svg)](https://hub.docker.com/r/mihalby/sqlscm)\n# Source code control of programmatic and other objects for MS SQL server\n\n## How it work\nhttps://github.com/mihalby/sqlscm/wiki/How-it-work\n\n## Build from source code\n ```\n git clone https://github.com/mihalby/sqlscm.git\n dotnet build \"sqlscm.csproj\" -c Release -o /app\n ```\n## Precompiled\n Precompiled binaries for released versions are available in the https://github.com/mihalby/sqlscm/releases\n## Run\n```\n cd /app\n dotnet sqlscm.dll\n```\nManage you app from swagger UI https://yourhost:8000/swagger\n\n### before run\nIn you app folder(/app) create cfg(/app/cfg) directory. Generate new certificate file(pfx format) for ssl use. And move it or you existing pfx to cfg folder. You find sample pfx file in this repo /cfg/aspncer.pfx, password for this file is 123123. \nCreate log4net.config file in /cfg directory, you find example /cfg/log4net.config.\nCreate settings.json file in /app/cfg folder. Copy to you app folder `SqlSCM.xml` file for correct swagger UI work.\n\n## First run\nGo to https://yourhost:8000/swagger and execute `/api/SCM/Start Start service` method on SCM controller. This action get all objects from databases, server objects and initialise\nyour repository in ProjectFolder. If git:remote is set git pull from remote. After each restart application you must execute action \"start service\" now.\n\n## Docker\nDocker images are available on [DockerHub.](https://hub.docker.com/r/mihalby/sqlscm)\nYou can launch a container for trying it out with\n`$ docker pull mihalby/sqlscm:latest && docker run --privileged=true -e \"TZ=YouTZ\" -d -v /path_to_log:/app/logs -v /path_2_cfg:/app/cfg -v /path_2_project:/app/folders/project -p 8110:8000 --name mySQLSCM mihalby/sqlscm:latest`\n\n## settings.json\n- SSL:pfxPassword - password for pfx file.\n\n- Main:TimeOut - getter timeout\n- Main:GetAllObjects2FileCommand - this command get all objects small decsription defined types for export to json file.\n- Main:GetGrants - this command get all grants to objects for export to json file.\n\n- Servers - servers array, each server contains:\n Name - server name\n ConStr - connection string\n DataBases - database names array\n\n- Folders:ProjectFolder - path to you local git repository. \n`!!!Important - this folder may be exist.`\n\n- git:user.email - your git user email\n- git:user.name - your git username\n- git:remote - url to you remote repo. Support http, https or ssh. If you are use ssh you need generate or export ssh keys.\n\n## sample folder and files structure\n```\n/App\n SqlSCM.xml #for swagger\n /cfg\n settings.json\n aspncer.pfx\n log4net.config\n /logs\n /Project\n /ServerName1\n /J\n\t /LS\n /DataBaseName1\n /P\n /FN\n\t /U\n\t /V\n\t /DataBaseName2\n /P\n /FN\n\t /U\n\t /V \n /ServerName2\n /J\n\t/LS\n\t...\n```\n## settings.json sample\n```\n{\r\n \"Main\": {\r\n \"TimeOut\": 40,\r\n \"GetAllObjects2FileCommand\": \"SELECT name,xtype,crdate FROM sysobjects WITH (nolock) WHERE xtype IN ('U','P','FN','V','TF') ORDER BY xtype,name\",\r\n \"GetGrants\": \"select princ.name,princ.type_desc,perm.permission_name,perm.state_desc,perm.class_desc,object_name(perm.major_id) AS objectName from sys.database_principals princ left join sys.database_permissions perm on perm.grantee_principal_id = princ.principal_id\"\r\n },\r\n \"SSL\": {\r\n \"pfxPassword\": \"123123\"\r\n },\r\n \"Servers\": [\r\n {\r\n \"Name\": \"Server1\",\r\n \"ConStr\": \"workstation id=sqlscm;packet size=4096;user id=user;data source=srv1;persist security info=False;password=pwd\",\r\n \"DataBases\": [ \"DB1_1\", \"DB1_2\" ]\r\n },\r\n {\r\n \"Name\": \"Server2\",\r\n \"ConStr\": \"workstation id=sqlscm;packet size=4096;user id=user;data source=srv2;persist security info=False;password=pwd\",\r\n \"DataBases\": [ \"DB1_1\", \"DB1_2\" ]\r\n }\r\n ],\r\n \"Jwt\": {\r\n \"key\": \"jwt key\"\r\n },\r\n \"Folders\": {\r\n \"ProjectFolder\": \"./Project\"\r\n },\r\n \"git\": {\r\n \"user.email\": \"test@test.us\",\r\n \"user.name\": \"testUser\",\r\n \"remote\": \"none\"\r\n }\r\n}\n```\n## log4net.config sample\n```\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\n```\n## Having questions? \nMail [me](mail:mihalby@gmail.com)","has_starred","hub_user","immutable_tags_settings",{"_71":11,"_72":73},"enabled","rules",[74],".*","is_automated","permissions",{"_78":17,"_79":11,"_80":11},"read","write","admin","user","storage_size",618448402,"orgData","recentTags",[87,125],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":96,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},"content_type","creator",4817731,"full_size",98450596,"id",43343328,"images",[97],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},"architecture","amd64","digest","sha256:54bd2e56e8f13032169c143c5c418e14ca34112bd8695f2cb9a02f59c422c56d","features","","last_pulled","2026-09-23T13:23:36.432333357Z","last_pushed","2020-03-28T13:04:09Z","os","linux","os_features","os_version","size","variant","2020-03-28T13:04:08.944401Z","last_updater","last_updater_username","media_type","latest","repository",6494179,"tag_last_pulled","tag_last_pushed","tag_status","v2",{"_88":40,"_89":90,"_91":126,"_93":127,"_95":128,"_46":133,"_115":90,"_116":29,"_117":52,"_53":134,"_119":120,"_121":131,"_122":133,"_123":62,"_124":17},98382104,46022833,[129],{"_98":99,"_100":130,"_102":103,"_104":131,"_106":132,"_108":109,"_110":103,"_111":-5,"_112":126,"_59":62,"_113":-5},"sha256:03b06a8e4759f34868cdcea71d21aa0b800a498c3ba8e241ca769cf28d792e58","2026-09-23T10:22:03.79298751Z","2019-02-03T11:58:58Z","2019-02-03T11:58:57.462252Z","v1.3","sbxKitMetadata","isPotentialSpam","isHubSbxKitsEnabled","showSbxLogoOverride","sbxTrademarkText","displaySecurityMetadata","tagAttestations","tagsHaveAttestations",[],"routes/_layout.r.$namespace.$reponame.tags",{"_34":146,"_153":154,"_142":167,"_168":11},{"_36":147,"_38":148,"_41":42,"_43":44,"_45":11,"_46":47,"_48":49,"_50":149,"_53":31,"_28":29,"_54":55,"_56":40,"_57":58,"_59":60,"_61":62,"_63":-5,"_64":58,"_65":66,"_67":11,"_68":29,"_69":150,"_75":11,"_76":152,"_81":29,"_82":83},[],[40],[52],{"_71":11,"_72":151},[74],{"_78":17,"_79":11,"_80":11},"tags",{"_155":156,"_157":-5,"_158":-5,"_159":160},"count",2,"next","previous","results",[161,164],{"_88":40,"_89":90,"_91":92,"_93":94,"_95":162,"_46":114,"_115":90,"_116":29,"_117":52,"_53":118,"_119":120,"_121":105,"_122":114,"_123":62,"_124":17},[163],{"_98":99,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":103,"_111":-5,"_112":92,"_59":62,"_113":-5},{"_88":40,"_89":90,"_91":126,"_93":127,"_95":165,"_46":133,"_115":90,"_116":29,"_117":52,"_53":134,"_119":120,"_121":131,"_122":133,"_123":62,"_124":17},[166],{"_98":99,"_100":130,"_102":103,"_104":131,"_106":132,"_108":109,"_110":103,"_111":-5,"_112":126,"_59":62,"_113":-5},[],"canDeleteTags","actionData","errors"]

mihalby/sqlscm

Tags for mihalby/sqlscm