{"id":39150,"date":"2019-10-31T22:28:07","date_gmt":"2019-10-31T19:28:07","guid":{"rendered":"https:\/\/prohoster.info\/blog\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server\/"},"modified":"2019-10-31T22:28:07","modified_gmt":"2019-10-31T19:28:07","slug":"10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","title":{"rendered":"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/e464b4d3638fd12cbc8072190e9388e4.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nTere, Habr! Meie t\u00f6\u00f6tame tihedalt koos <noindex><a rel=\"nofollow\" href=\"https:\/\/www.quest.com\/\">Quest Software<\/a><\/noindex>, ja sel aastal nad ostsid <noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/\">ApexSQL<\/a><\/noindex> \u2014 lahenduste tootja Microsoft SQL Serveri andmebaaside haldamiseks ja j\u00e4lgimiseks. Venemaal, nagu me arvame, ei teata neist palju. Oma kodulehel kirjutavad nad: \u201eKiller tools for SQL Server\u201d. See k\u00f5lab \u00e4hvardavalt. Meil tekkis idee tutvustada seda tootjat ja uurida, mis nende lahendustes nii \u201etappvat\u201d on. Alustame h\u00fcpete osast \u2014 tasuta toodetest. P\u00e4rast neid on l\u00fchike osa kommertstooteid. Loodan, et need programmid osutuvad teile kasulikuks. Palun lugege edasi.<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\nSelles artiklis:<\/p>\n<ol>\n<li><noindex><a rel=\"nofollow\" href=\"#compare\">ApexSQL Compare<\/a><\/noindex> \u2014 t\u00f6\u00f6riist SQL-koodi, failide ja kaustade v\u00f5rdlemiseks. T\u00f6\u00f6tab ka kui laiendus SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#decrypt\">ApexSQL Decrypt<\/a><\/noindex> \u2014 voogedastuse dekr\u00fcpteerimine SQL Serveri objektidest: protseduurid, funktsioonid, trigerid ja vaated. T\u00f6\u00f6tab ka kui laiendus SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#discover\">ApexSQL Discover<\/a><\/noindex> \u2014 SQL Serveri instantside ja sellega seotud teenuste SSRS, SSAS ja SSIS avastamine.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#refactor\">ApexSQL Refactor<\/a><\/noindex> \u2014 t\u00f6\u00f6riist SQL-koodi refaktoreerimiseks ja vormindamiseks. T\u00f6\u00f6tab laiendusena SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#model\">ApexSQL Model<\/a><\/noindex> \u2014 SQL Serveri objektide diagrammide loomine. T\u00f6\u00f6tab samuti laiendusena SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#plan\">ApexSQL Plan<\/a><\/noindex> \u2014 t\u00f6\u00f6riist t\u00e4itmisplaanide optimeerimiseks. T\u00f6\u00f6tab samuti laiendusena SSMS-i jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#complete\">ApexSQL Complete<\/a><\/noindex> \u2014 t\u00f6\u00f6riist, mis automaatselt l\u00f5petab SQL-k\u00e4sklused ja v\u00f5imaldab lisada enda snippe (klahvikombinatsioonid automaatseks t\u00e4itmiseks). T\u00f6\u00f6tab samuti laiendusena SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#propagate\">ApexSQL Propagate<\/a><\/noindex> \u2014 t\u00f6\u00f6riist SQL-koodi t\u00e4itmiseks mitmes andmebaasis korraga.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#search\">ApexSQL Search<\/a><\/noindex> \u2014 utiliit andmete ja objektide otsimiseks SQL Serveri s\u00fcgavustest. T\u00f6\u00f6tab laiendusena SSMS-i v\u00f5i Visual Studio jaoks.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"#devops\">ApexSQL DevOps Toolkit<\/a><\/noindex> \u2014 t\u00f6\u00f6riist CI\/CD pipeline'ide loomiseks. Ainuke k\u00f5ikidest siin loetletud toodetest, millel on veebikonsol.<\/li>\n<\/ol>\n<p>\nIga toode on osa ApexSQL-i tasuliste lahenduste funktsionaalsusest. Artikli l\u00f5pus anname l\u00fchikese \u00fclevaate, millised kommertslahendused neil on. <\/p>\n<p><noindex><a rel=\"nofollow\" name=\"compare\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-compare.aspx\">1. ApexSQL Compare<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/9fcd22aa5ada42286d6a0ae01ff9fca3.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"7sLweyiOU30\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/7sLweyiOU30\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>Compare abiliteerib failide, kaustade ja SQL Serveri objektide v\u00f5rdlemist. Toetatakse kahesuunalist v\u00f5rdlemist ja erinevate objektide \u00fchendamiseks skripti genereerimist. Tootes on olemas C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic, XML s\u00fcntaksihighlighting.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/bb03fe4d8bb168da47515425c844f236.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nPeamised omadused \u2014 integreerimine SSMS-i ja Visual Studio, objektide kutsumine erinevate andmebaasi instantside vahel otse Object Explorerist ja <noindex><a rel=\"nofollow\" href=\"https:\/\/knowledgebase.apexsql.com\/apexsql-compare-command-line-interface-cli-switches\/\">toetatud CLI kaudu t\u00f6\u00f6tamine<\/a><\/noindex>.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"decrypt\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-decrypt.aspx\">2. ApexSQL Decrypt<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/fd7174b9a5b7ee28b849a2e8715492c8.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"1OuX0MJN8kQ\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/1OuX0MJN8kQ\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>Decrypt v\u00f5imaldab SSMS-i v\u00f5i Visual Studio liideses \u00fche kl\u00f5psuga dekr\u00fcpteerida protseduuri, funktsiooni, k\u00e4ivituspunkti v\u00f5i vaate.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/f404c589dfcb9d1ae9c33086ef14d641.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nLiideses on v\u00f5imalik vaadata dekr\u00fcpteerimise DDL skripti. Toetatakse samal ajal mitme SQL Serveri instantsi \u00fchendamist.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"discover\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-discover.aspx\">3. ApexSQL Discover<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/25b5b4d327ea78bbd32dc3d9461e5ff7.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSQL Serveri, SSRS, SSAS ja SSIS olemasolevate instantside tuvastamine IP-aadresside vahemiku j\u00e4rgi ning \u00fcksikasjaliku teabe vaatamine.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/2ea7d13202454727e1488d3986dc6d63.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nLiidese kaudu saab seadistada andmebaasi avastamise ajakava. ApexSQL Discover v\u00f5ib saata avastamisprotsessi tulemuste kohta teateid e-postile.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"refactor\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-refactor.aspx\">4. ApexSQL Refactor<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/9118d255fc2dd599aacc7b3abbbd8150.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"_lH7yihq6TA\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/_lH7yihq6TA\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>Koodivormindust saab teha kas kastip\u00f5hise profiili alusel v\u00f5i luua enda oma, et kood v\u00e4ljas n\u00e4eks nii tuttav v\u00e4lja kui v\u00f5imalik. Refactor v\u00f5ib esile tuua kasutamata muutujaid koodis, kapseldada koodiblokke protseduuridesse ning avada \u201e*\u201d t\u00e4ieliku nimekirja.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/b4aaa2c8c744f72dac1ba6f95970afba.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n\u00dcks kasulik funktsioon on tabelite jagamine, et eraldada k\u00f5ige v\u00e4hem kasutatavad veerud. Refactor teavitab objekte, millele see jagamine m\u00f5ju avaldab.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/b4d1d204fdcab45f5087a41da02864a7.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSamuti saab Refactori liideses ohutult muuta objektide nimesid, muutes k\u00f5iki s\u00f5ltuvusi.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/4d7b9509787b9c9a1ff781dd4815b87c.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nNende ja teiste funktsioonide kohta saab rohkem teavet lehelt, kus on <noindex><a rel=\"nofollow\" href=\"https:\/\/knowledgebase.apexsql.com\/apexsql-refactor-overview\/\">utiliidi kirjeldus<\/a><\/noindex>.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"model\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-model.aspx\">5. ApexSQL Model<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/de1050a83f4997e70ed6e9578b7a4173.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nUtiliit visualiseerib SQL Serveri objekte ja nendevahelisi seoseid. Samas liideses saab muuta objektide seadistust ja genereerida vastavat DDL-koodi. K\u00f5iki visualiseerimisi saab eksportida piltidena.<\/p>\n<p>Modeli funktsionaalsust laiendatakse kommertstooteid kasutades <noindex><a rel=\"nofollow\" href=\"https:\/\/knowledgebase.apexsql.com\/compare-ssis-packages-export-difference-results\/\">Diff<\/a><\/noindex> ja <noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-doc.aspx\">Doc<\/a><\/noindex>. Esimese toote abil saab v\u00f5rrelda mudelit praeguse seisuga andmebaasis v\u00f5i v\u00f5rrelda kaht erinevat andmebaasi mudelit, teine toode on vajalik andmebaasi objektide dokumenteerimiseks.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"plan\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-plan.aspx\">6. ApexSQL Plan<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/a1b558848a6ffd876ecd8f594f5033c1.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"P01_Zd11HX0\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/P01_Zd11HX0\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>See t\u00f6\u00f6riist on m\u00f5eldud j\u00f5udluse optimeerimiseks. Samuti on ApexSQL Plan abil v\u00f5imalik eksportida plaane aruannetena HTML ja XML formaatides. Sage kasutusjuht selle t\u00f6\u00f6riista puhul on k\u00e4esoleva plaani ja muudetud plaani v\u00f5rdlemine erinevate omaduste p\u00f5hjal.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/e881d9d59d9cba1f483cc4c1f5cd5a44.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nApexSQL Plan toetab query store'i laadimist ning esitleb nende p\u00e4ringute omadusi juhtpaneelide kujul.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"complete\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-complete.aspx\">7. ApexSQL Complete<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/6d73cf9cebcc1d300c3e7be5a45cefe6.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"UC-felOMDdk\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/UC-felOMDdk\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>Koodi kirjutamise kiirendi. T\u00f6\u00f6riista liideses on v\u00f5imalik seadistada alias'id, snipid ja s\u00fcntaksihighlighting.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"propagate\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-propagate.aspx\">8. ApexSQL Propagate<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/16ac64b570c2bf8760b4b902e469dfee.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nApexSQL Propagate'is saab seadistada koodi t\u00e4itmist erinevates SQL Serveri andmebaasides ning m\u00e4\u00e4rata t\u00e4itmise j\u00e4rjekorra.<\/p>\n<p><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/3604a30ace6998b5aec9c11c8cd4f2fc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nT\u00e4itunud koodi tulemused parsitakse t\u00f6\u00f6riista poolt ja salvestatakse mugavaks tulemuste vaatamiseks.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"search\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-search.aspx\">9. ApexSQL Search<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/38c3ef32fdc608a0970e8bd2c843d65a.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"W088UO2efPY\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/W088UO2efPY\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>T\u00f6\u00f6riist otsib andmebaasi struktuurist. Siit on turvaline \u00fcmber nimetada objekte ja j\u00e4lgida nende seoseid. Otsingu tulemused eksporditakse HTML, CSV ja Excel formaatidena. <\/p>\n<p><noindex><a rel=\"nofollow\" name=\"devops\"><\/a><\/noindex><\/p>\n<h1><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-devops.aspx\">10. ApexSQL DevOps Toolkit<\/a><\/noindex><\/h1>\n<p>\n<img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/97f51663a2b36e0f966cae811368092d.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<b class=\"spoiler_title\">L\u00fchike video t\u00f6\u00f6p\u00f5him\u00f5tete ja v\u00f5imaluste kohta<\/b><center><div class=\"youtube-placeholder\" data-id=\"YlkmFyszQjs\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/YlkmFyszQjs\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p>T\u00f6\u00f6riista taga t\u00f6\u00f6tab PowerShelli kood. Build, Review, Document ja Deploy on arendajale kergesti k\u00e4tte saadavad ApexSQL DevOps Toolkiti liidese kaudu. Siin on v\u00f5imalik genereerida s\u00fcnteetilisi andmeid, automaatselt k\u00e4ivitada \u00fcksusteste ja dokumenteerida muudatusi. See saab liituda TeamCity, Jenkins ja teistega pistikprogrammina.<\/p>\n<p>ApexSQL teadmistebaasis on <noindex><a rel=\"nofollow\" href=\"https:\/\/knowledgebase.apexsql.com\/apexsql-devops-knowledgebase-table-of-contents\/\">huvitavad artiklid<\/a><\/noindex> DevOpsi kohta andmebaaside keskkonnas.<\/p>\n<p>N\u00fc\u00fcd, kui oleme tasuta lahendustega tutvunud, anname \u00fclevaate tasulistest lahendustest, mis pakuvad loomulikult v\u00f5imsamat funktsionaalsust.<\/p>\n<ol>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-audit.aspx\">ApexSQL Audit<\/a><\/noindex> on t\u00f6\u00f6riist andmebaasi auditeerimiseks turvastandardite t\u00e4itmise osas, sealhulgas toetatud on HIPAA, GDPR, PCI. Saadaval on aruanded ja muudatuste ajaloo vaatamine.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/8b54653dd1ec4cce5c671ff12ffede11.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"fQj-d09U8FY\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/fQj-d09U8FY\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-backup.aspx\">ApexSQL Backup<\/a><\/noindex> automaatne inkrementaalsete varunduste, tehingulogide ja t\u00e4ielike varunduste loomise automatiseerimine. Toetatakse taastamist kindlal ajal, saab luua mallid varunduste loomiseks ja paindlikult seadistada varundusplaanid.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/76dab74c510fff869b0c4feacae7e522.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"2BRTo31_j50\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/2BRTo31_j50\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-defrag.aspx\">ApexSQL Defrag<\/a><\/noindex> on utiliit defragmenteerimise j\u00e4lgimiseks ja haldamiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/381c72b0769c42dfdf429b9444fda09e.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"rYdnBCSEz5M\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/rYdnBCSEz5M\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-job.aspx\">ApexSQL Job<\/a><\/noindex> \u2014 projektihaldust\u00f6\u00f6riist, mis sisaldab ajaloo, ajakava ja teavituste haldust.\n<p><b class=\"spoiler_title\">Vaata ekraanipilti<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/687d9e27f6c96f97d94c5c8f5a2c8e70.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-log.aspx\">ApexSQL Log<\/a><\/noindex> \u2014 tehingute logi lugemise t\u00f6\u00f6riist auditeerimiseks, replikatsiooniks v\u00f5i muudatuste tagasiviimiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/5d7bd89a2baff5be12d834d10c3266c5.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"5fF7QivlWKc\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/5fF7QivlWKc\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-recover.aspx\">ApexSQL Recover<\/a><\/noindex> \u2014 t\u00f6\u00f6riist rikutud, kustutatud v\u00f5i kaotatud andmete taastamiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/f65e6630c6fff049372a72bc08a62d05.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"C3X1PylOERU\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/C3X1PylOERU\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-analyze.aspx\">ApexSQL Analyze<\/a><\/noindex> \u2014 t\u00f6\u00f6riist andmebaasi seoste anal\u00fc\u00fcsimiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/7031de29e227a15183290db48432a0bc.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"SBQrFF9dKeA\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/SBQrFF9dKeA\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-build.aspx\">ApexSQL Build<\/a><\/noindex> \u2014 t\u00f6\u00f6riist andmebaasi loomise automatiseerimiseks. Saab \u00fchendada versioonihalduss\u00fcsteemidega.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/f1f012a502927b5a421ee438b4d4a5a2.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"i_72k6m_HOM\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/i_72k6m_HOM\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-enforce.aspx\">ApexSQL Enforce<\/a><\/noindex> \u2014 SQL-koodi t\u00e4iustamise t\u00f6\u00f6riist.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/12717bddd4682de0b621e5a4b9e249ad.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"NTpnIWRyMk8\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/NTpnIWRyMk8\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-generate.aspx\">ApexSQL Generate<\/a><\/noindex> \u2014 t\u00f6\u00f6riist miljonite andmerealiste genereerimiseks \u00fche klikiga. Toetab testandmete eksportimist SQL, XML, CSV, JSON ja Excel formaates.\n<p><b class=\"spoiler_title\">Vaata ekraanipilti<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/797d977603a95c72917980cdee9cc673.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-mask.aspx\">ApexSQL Mask<\/a><\/noindex> \u2014 t\u00f6\u00f6riist tundlike andmete otsimiseks, klassifitseerimiseks ja varjamiseks andmebaasides. Sisaldab \u00fcle 220 eelm\u00e4\u00e4ratud maski ja 55+ sisseehitatud filtrit klassifitseerimiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanipilti<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/9a473e6eb537b8ab063b6d9975f97a54.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-script.aspx\">ApexSQL Script<\/a><\/noindex> \u2014 t\u00f6\u00f6riist DDL- ja DML-skripti genereerimiseks ning t\u00e4idetavate installipakettide loomiseks.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/67cd66beeae733462ab0e37c3b365045.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"HSVoGPoR_YE\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/HSVoGPoR_YE\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-source-control.aspx\">ApexSQL Source Control<\/a><\/noindex> \u2014 t\u00f6\u00f6riist versioonihalduss\u00fcsteemide integreerimiseks SSMS-iga.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/cf47489043cec345086f03e1f0c19e46.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"lAt22fvwsNM\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/lAt22fvwsNM\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-trigger.aspx\">ApexSQL Trigger<\/a><\/noindex> \u2014 andmebaasi andmete auditeerimine ja DML-isse t\u00f5lkimine.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/7e9441c468e65a6aeb86d64b6ce622f8.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"jtvhhUjyD60\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/jtvhhUjyD60\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/www.apexsql.com\/sql-tools-unit-test.aspx\">ApexSQL Unit Test<\/a><\/noindex> \u2014 t\u00f6\u00f6riist \u00fcksuse testide t\u00e4itmiseks otse SSMS-i konsoolilt.\n<p><b class=\"spoiler_title\">Vaata ekraanikuva ja videot<\/b><img decoding=\"async\" alt=\"10 tasuta t\u00f6\u00f6riista ApexSQL Microsoft SQL Serveri andmebaaside haldamiseks\" src=\"\/wp-content\/uploads\/2019\/10\/f1f3d3ddfe6fe0ce7aa6e683eb26f313.jpg\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"TpBDx3crzpw\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/TpBDx3crzpw\/hqdefault.jpg\" alt=\"Vaata videot\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center>\n<\/li>\n<\/ol>\n<p>\nKirjuta kommentaaridesse, milliseid andmebaasi kontrollimise ja haldamise t\u00f6\u00f6riistu juba kasutad ning milliseid \u00fclesandeid nende abil lahendad.<\/p>\n<p>K\u00fcsimuste esitamiseks ApexSQL toodete kohta, kaupade testimiseks v\u00f5i hindade t\u00e4psustamiseks j\u00e4ta palun p\u00e4ring <noindex><a rel=\"nofollow\" href=\"https:\/\/gals.software\/#feedback\">tagasiside vormi kaudu meie veebisaidil<\/a><\/noindex>.<\/p>\n<p>Kui lahendad keerulisi j\u00e4relevalve- ja haldus\u00fclesandeid, loe meie varasemaid artikleid Habr's:<\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/galssoftware\/blog\/443238\/\">Mitmete andmebaaside j\u00e4lgimine \u00fchest liidesest.<\/a><\/noindex><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/galssoftware\/blog\/464963\/\">SSQL Serveri j\u00f5udluse probleemide kiire lokaliseerimine.<\/a><\/noindex><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/galssoftware\/blog\/447512\/\">Muudatuste auditeerimine Microsofti infrastruktuuris (sealhulgas SQL Server).<\/a><\/noindex><\/p>\n<p>Ja veel, saad alati tellida meie <noindex><a rel=\"nofollow\" href=\"https:\/\/www.facebook.com\/GalsSoftware\/\">Facebooki lehe<\/a><\/noindex>.<br \/>\n<br \/>Allikas: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/galssoftware\/blog\/471884\/\">habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041c\u044b \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 Quest Software, \u0438 \u0432 \u044d\u0442\u043e\u043c \u0433\u043e\u0434\u0443 \u043e\u043d\u0438 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u043b\u0438 ApexSQL \u2014 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server. \u0412 \u0420\u043e\u0441\u0441\u0438\u0438 \u043e\u0431 \u044d\u0442\u0438\u0445 \u0440\u0435\u0431\u044f\u0442\u0430\u0445, \u043a\u0430\u043a \u043d\u0430\u043c \u043a\u0430\u0436\u0435\u0442\u0441\u044f, \u0437\u043d\u0430\u044e\u0442 \u043c\u0430\u043b\u043e. \u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0441\u0432\u043e\u0435\u0433\u043e \u0441\u0430\u0439\u0442\u0430 \u043e\u043d\u0438 \u043f\u0438\u0448\u0443\u0442 \u00abKiller tools for SQL Server\u00bb. \u0417\u0432\u0443\u0447\u0438\u0442 \u0443\u0433\u0440\u043e\u0436\u0430\u044e\u0449\u0435. \u0423 \u043d\u0430\u0441 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0438\u0434\u0435\u044f \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":29381,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-39150","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041c\u044b \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 Quest Software, \u0438 \u0432 \u044d\u0442\u043e\u043c \u0433\u043e\u0434\u0443 \u043e\u043d\u0438 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u043b\u0438 ApexSQL \u2014 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server. \u0412 \u0420\u043e\u0441\u0441\u0438\u0438 \u043e\u0431 \u044d\u0442\u0438\u0445 \u0440\u0435\u0431\u044f\u0442\u0430\u0445, \u043a\u0430\u043a \u043d\u0430\u043c \u043a\u0430\u0436\u0435\u0442\u0441\u044f, \u0437\u043d\u0430\u044e\u0442 \u043c\u0430\u043b\u043e. \u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0441\u0432\u043e\u0435\u0433\u043e \u0441\u0430\u0439\u0442\u0430 \u043e\u043d\u0438 \u043f\u0438\u0448\u0443\u0442 \u00abKiller tools for SQL Server\u00bb. \u0417\u0432\u0443\u0447\u0438\u0442 \u0443\u0433\u0440\u043e\u0436\u0430\u044e\u0449\u0435. \u0423 \u043d\u0430\u0441 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0438\u0434\u0435\u044f \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"et_EE\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd4710 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0443\u0442\u0438\u043b\u0438\u0442 ApexSQL \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041c\u044b \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 Quest Software, \u0438 \u0432 \u044d\u0442\u043e\u043c \u0433\u043e\u0434\u0443 \u043e\u043d\u0438 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u043b\u0438 ApexSQL \u2014 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server. \u0412 \u0420\u043e\u0441\u0441\u0438\u0438 \u043e\u0431 \u044d\u0442\u0438\u0445 \u0440\u0435\u0431\u044f\u0442\u0430\u0445, \u043a\u0430\u043a \u043d\u0430\u043c \u043a\u0430\u0436\u0435\u0442\u0441\u044f, \u0437\u043d\u0430\u044e\u0442 \u043c\u0430\u043b\u043e. \u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0441\u0432\u043e\u0435\u0433\u043e \u0441\u0430\u0439\u0442\u0430 \u043e\u043d\u0438 \u043f\u0438\u0448\u0443\u0442 \u00abKiller tools for SQL Server\u00bb. \u0417\u0432\u0443\u0447\u0438\u0442 \u0443\u0433\u0440\u043e\u0436\u0430\u044e\u0449\u0435. \u0423 \u043d\u0430\u0441 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0438\u0434\u0435\u044f \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2019-10-31T19:28:07+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T19:28:07+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd4710 tasuta ApexSQL t\u00f6\u00f6riista Microsoft SQL Serveri andmebaaside haldamiseks | ProHoster","description":"Tere, Habr! Me tegeleme palju Quest Software'iga ja sel aastal nad omandasid ApexSQL \u2014 Microsoft SQL Serveri andmebaaside haldamise ja j\u00e4lgimise lahenduste tootja. Venemaal on nende kohta meie arvates v\u00e4he infot. Oma veebisaidi esilehel nad \u00fctlevad \u201eTappja t\u00f6\u00f6riistad SQL Serveri jaoks\u201c. See k\u00f5lab \u00e4hvardavalt. Meil tekkis idee tutvustada","canonical_url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"et_EE","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd4710 \u0431\u0435\u0441\u043f\u043b\u0430\u0442\u043d\u044b\u0445 \u0443\u0442\u0438\u043b\u0438\u0442 ApexSQL \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0430\u0437\u0430\u043c\u0438 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server | ProHoster","og:description":"\u041f\u0440\u0438\u0432\u0435\u0442, \u0425\u0430\u0431\u0440! \u041c\u044b \u043c\u043d\u043e\u0433\u043e \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u043c \u0441 Quest Software, \u0438 \u0432 \u044d\u0442\u043e\u043c \u0433\u043e\u0434\u0443 \u043e\u043d\u0438 \u043f\u0440\u0438\u043e\u0431\u0440\u0435\u043b\u0438 ApexSQL \u2014 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044f \u0440\u0435\u0448\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0443\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u044f \u0438 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0431\u0430\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 Microsoft SQL Server. \u0412 \u0420\u043e\u0441\u0441\u0438\u0438 \u043e\u0431 \u044d\u0442\u0438\u0445 \u0440\u0435\u0431\u044f\u0442\u0430\u0445, \u043a\u0430\u043a \u043d\u0430\u043c \u043a\u0430\u0436\u0435\u0442\u0441\u044f, \u0437\u043d\u0430\u044e\u0442 \u043c\u0430\u043b\u043e. \u041d\u0430 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0441\u0432\u043e\u0435\u0433\u043e \u0441\u0430\u0439\u0442\u0430 \u043e\u043d\u0438 \u043f\u0438\u0448\u0443\u0442 \u00abKiller tools for SQL Server\u00bb. \u0417\u0432\u0443\u0447\u0438\u0442 \u0443\u0433\u0440\u043e\u0436\u0430\u044e\u0449\u0435. \u0423 \u043d\u0430\u0441 \u043f\u043e\u044f\u0432\u0438\u043b\u0430\u0441\u044c \u0438\u0434\u0435\u044f \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u0438\u0442\u044c","og:url":"https:\/\/prohoster.info\/et\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2019-10-31T19:28:07+00:00","article:modified_time":"2019-10-31T19:28:07+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"39150","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-24 00:58:23","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 00:55:35","updated":"2026-01-24 00:58:23"},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/39150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/comments?post=39150"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/posts\/39150\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media\/29381"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/media?parent=39150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/categories?post=39150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/et\/wp-json\/wp\/v2\/tags?post=39150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}