{"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\/hu\/blog\/administrirovanie\/10-besplatnyh-utilit-apexsql-dlya-upravleniya-bazami-dannyh-microsoft-sql-server","title":{"rendered":"10 ingyenes ApexSQL seg\u00e9dprogram a Microsoft SQL Server adatb\u00e1zisok kezel\u00e9s\u00e9re","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

\"10
\n
\nHell\u00f3, Habr! Sokat dolgozunk a Quest Software<\/a><\/noindex>, \u00e9s id\u00e9n megv\u00e1s\u00e1rolt\u00e1k ApexSQL<\/a><\/noindex> \u2014 az SQL Server adatb\u00e1zisok kezel\u00e9s\u00e9re \u00e9s megfigyel\u00e9s\u00e9re sz\u00e1nt megold\u00e1sok gy\u00e1rt\u00f3ja. Oroszorsz\u00e1gban err\u0151l a sr\u00e1cok a mi v\u00e9lem\u00e9ny\u00fcnk szerint nem sokat tudnak. A hivatalos weboldalukon azt \u00edrj\u00e1k: \u201eKiller tools for SQL Server.\u201d Ez f\u00e9lelmetes\u00fcl hangzik. \u00d6tletet kaptunk, hogy bemutassuk ezt a sz\u00e1ll\u00edt\u00f3t, \u00e9s kider\u00edts\u00fck, hogy mi is olyan hal\u00e1los a megold\u00e1saikban. Kezdj\u00fck a felhajt\u00f3 r\u00e9sz\u00e9vel \u2014 a ingyenes term\u00e9kekkel. Ezek ut\u00e1n egy r\u00f6vid r\u00e9sz a kereskedelmi term\u00e9kekr\u0151l. Rem\u00e9lem, ezek a programok hasznosak lesznek sz\u00e1modra. K\u00e9rlek, n\u00e9zd meg.
\n<\/a><\/noindex>
\nA cikkben:<\/p>\n

    \n
  1. ApexSQL Compare<\/a><\/noindex> \u2014 egy eszk\u00f6z SQL-k\u00f3d, f\u00e1jlok \u00e9s mapp\u00e1k \u00f6sszehasonl\u00edt\u00e1s\u00e1ra. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  2. ApexSQL Decrypt<\/a><\/noindex> \u2014 SQL Server objektumok, p\u00e9ld\u00e1ul elj\u00e1r\u00e1sok, funkci\u00f3k, trigger-ek \u00e9s n\u00e9zetek (view) folyamatos dek\u00f3dol\u00e1sa. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  3. ApexSQL Discover<\/a><\/noindex> \u2014 SQL Server p\u00e9ld\u00e1nyok \u00e9s a kapcsol\u00f3d\u00f3 SSRS, SSAS \u00e9s SSIS szolg\u00e1ltat\u00e1sok felfedez\u00e9se.<\/li>\n
  4. ApexSQL Refactor<\/a><\/noindex> \u2014 eszk\u00f6z SQL-k\u00f3d \u00e1talak\u00edt\u00e1s\u00e1ra \u00e9s form\u00e1z\u00e1s\u00e1ra. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  5. ApexSQL Model<\/a><\/noindex> \u2014 SQL Server objektumdiagramok l\u00e9trehoz\u00e1sa. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  6. ApexSQL Plan<\/a><\/noindex> \u2014 eszk\u00f6z az Execution tervek optimaliz\u00e1l\u00e1s\u00e1ra. SSMS b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  7. ApexSQL Complete<\/a><\/noindex> \u2014 eszk\u00f6z, amely automatikusan befejezi az SQL utas\u00edt\u00e1sokat, \u00e9s lehet\u0151v\u00e9 teszi saj\u00e1t snippet-ek (billenty\u0171kombin\u00e1ci\u00f3k az automatikus kit\u00f6lt\u00e9shez) hozz\u00e1ad\u00e1s\u00e1t. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  8. ApexSQL Propagate<\/a><\/noindex> \u2014 eszk\u00f6z SQL-k\u00f3d v\u00e9grehajt\u00e1s\u00e1ra t\u00f6bb DB-n egyszerre.<\/li>\n
  9. ApexSQL Search<\/a><\/noindex> \u2014 seg\u00e9dprogram az adatok \u00e9s objektumok keres\u00e9s\u00e9re a SQL Server m\u00e9ly\u00e9n. SSMS vagy Visual Studio b\u0151v\u00edtm\u00e9nyek\u00e9nt is m\u0171k\u00f6dik.<\/li>\n
  10. ApexSQL DevOps Toolkit<\/a><\/noindex> \u2014 eszk\u00f6z CI\/CD pipeline-ok l\u00e9trehoz\u00e1s\u00e1ra. Az \u00f6sszes itt felsorolt term\u00e9k k\u00f6z\u00fcl egyed\u00fclik\u00e9nt van webes konzolja.<\/li>\n<\/ol>\n

    \nMinden term\u00e9k az ApexSQL fizet\u0151s megold\u00e1sainak egy funkci\u00f3j\u00e1t k\u00e9pezi. A cikk v\u00e9g\u00e9n r\u00f6viden bemutatjuk, hogy milyen kereskedelmi megold\u00e1saik vannak. <\/p>\n

    <\/a><\/noindex><\/p>\n

    1. ApexSQL Compare<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    A Compare lehet\u0151v\u00e9 teszi f\u00e1jlok, mapp\u00e1k \u00e9s SQL Server objektumok \u00f6sszehasonl\u00edt\u00e1s\u00e1t. T\u00e1mogatott a k\u00e9tir\u00e1ny\u00fa \u00f6sszehasonl\u00edt\u00e1s \u00e9s a k\u00fcl\u00f6nb\u00f6z\u0151 objektumok egyes\u00edt\u00e9s\u00e9hez sz\u00fcks\u00e9ges szkript gener\u00e1l\u00e1sa. Az interf\u00e9szen a seg\u00e9dprogram k\u00e9pes C#, C++, HTML, JavaScript, PostgreSQL, Python, T-SQL, Visual Basic \u00e9s XML szintaxis kiemel\u00e9s\u00e9re.<\/p>\n

    \"10
    \n
    \nKulcsfontoss\u00e1g\u00fa jellemz\u0151k \u2014 integr\u00e1ci\u00f3 az SSMS \u00e9s a Visual Studio alkalmaz\u00e1sokkal, az Object Explorerb\u0151l t\u00f6rt\u00e9n\u0151 \u00f6sszehasonl\u00edt\u00e1st lehet\u0151v\u00e9 tev\u0151 objektumok h\u00edv\u00e1sa k\u00fcl\u00f6nb\u00f6z\u0151 DB p\u00e9ld\u00e1nyokb\u00f3l \u00e9s     CLI-n kereszt\u00fcli m\u0171k\u00f6d\u00e9s t\u00e1mogat\u00e1sa.<\/a><\/noindex>.<\/p>\n

    <\/a><\/noindex><\/p>\n

    2. ApexSQL Decrypt<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    A Decrypt-kel az SSMS vagy Visual Studio interf\u00e9szen egy kattint\u00e1ssal dek\u00f3dolhatunk elj\u00e1r\u00e1sokat, funkci\u00f3kat, triggereket vagy n\u00e9zeteket.<\/p>\n

    \"10
    \n
    \nAz interf\u00e9szen megjelen\u00edthet\u0151 a dek\u00f3dol\u00e1si DDL szkript. T\u00e1mogatott a t\u00f6bb SQL Server p\u00e9ld\u00e1nyhoz val\u00f3 egyidej\u0171 csatlakoz\u00e1s.<\/p>\n

    <\/a><\/noindex><\/p>\n

    3. ApexSQL Discover<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nSQL Server p\u00e9ld\u00e1nyok, SSRS, SSAS \u00e9s SSIS szolg\u00e1ltat\u00e1sok az IP-c\u00edmek tartom\u00e1ny\u00e1nak alapj\u00e1n t\u00f6rt\u00e9n\u0151 azonos\u00edt\u00e1sa \u00e9s r\u00e9szletes inform\u00e1ci\u00f3k megtekint\u00e9se.<\/p>\n

    \"10
    \n
    \nAz interf\u00e9szen be\u00e1ll\u00edthat\u00f3 az adatb\u00e1zisok \u00fctemezett felfedez\u00e9se. Az ApexSQL Discover \u00e9rtes\u00edt\u00e9seket k\u00fcldhet az \u00e9szlel\u00e9si eredm\u00e9nyekr\u0151l e-mailben.<\/p>\n

    <\/a><\/noindex><\/p>\n

    4. ApexSQL Refactor<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    A k\u00f3d form\u00e1z\u00e1sa dobozprofil alapj\u00e1n v\u00e9gezhet\u0151, vagy saj\u00e1t profilt \u00e1ll\u00edthatunk be, hogy a k\u00f3d a legjobban ismer\u0151s legyen sz\u00e1munkra. A Refactor k\u00e9pes kiemelni a felhaszn\u00e1latlan v\u00e1ltoz\u00f3kat a k\u00f3dban, a k\u00f3dblokkokat elj\u00e1r\u00e1sokba becsomagolni, valamint kib\u0151v\u00edteni a \u201e*\u201d-t a teljes list\u00e1val.<\/p>\n

    \"10
    \n
    \nAz egyik hasznos funkci\u00f3 a t\u00e1bl\u00e1k sz\u00e9tv\u00e1laszt\u00e1sa a legkev\u00e9sb\u00e9 haszn\u00e1lt oszlopok elv\u00e1laszt\u00e1s\u00e1ra. A Refactor \u00e9rtes\u00edt\u00e9st k\u00fcld azokr\u00f3l az objektumokr\u00f3l, amelyeket \u00e9rint a sz\u00e9tv\u00e1laszt\u00e1s.<\/p>\n

    \"10
    \n
    \nAz interf\u00e9szen a Refactor seg\u00edts\u00e9g\u00e9vel biztons\u00e1gosan \u00e1tnevezhetj\u00fck az objektumokat, m\u00f3dos\u00edtva minden f\u00fcgg\u0151s\u00e9get.<\/p>\n

    \"10
    \n
    \nA fent eml\u00edtett \u00e9s egy\u00e9b funkci\u00f3kr\u00f3l b\u0151vebben a     seg\u00e9dprogram le\u00edr\u00e1sa oldalon lehet t\u00e1j\u00e9koz\u00f3dni.<\/a><\/noindex>.<\/p>\n

    <\/a><\/noindex><\/p>\n

    5. ApexSQL Model<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nA seg\u00e9dprogram vizualiz\u00e1lja az SQL Server objektumokat \u00e9s azok k\u00f6z\u00f6tti kapcsolatokat. Ugyanebben az interf\u00e9szen megv\u00e1ltoztathatjuk az objektumok konfigur\u00e1ci\u00f3j\u00e1t \u00e9s elk\u00e9sz\u00edthetj\u00fck a megfelel\u0151 DDL k\u00f3dot. Minden vizualiz\u00e1ci\u00f3 export\u00e1lhat\u00f3 k\u00e9pk\u00e9nt.<\/p>\n

    A Model funkcionalit\u00e1sa kereskedelmi term\u00e9kek seg\u00edts\u00e9g\u00e9vel b\u0151v\u00edthet\u0151. Diff<\/a><\/noindex> \u00e9s Doc<\/a><\/noindex>. Az els\u0151 term\u00e9k lehet\u0151v\u00e9 teszi a modell \u00f6sszehasonl\u00edt\u00e1s\u00e1t az adatb\u00e1zis aktu\u00e1lis \u00e1llapot\u00e1val vagy k\u00e9t k\u00fcl\u00f6nb\u00f6z\u0151 adatb\u00e1zis modellj\u00e9nek \u00f6sszehasonl\u00edt\u00e1s\u00e1t, m\u00edg a m\u00e1sodik term\u00e9k az adatb\u00e1zis objektumainak dokument\u00e1l\u00e1s\u00e1ra szolg\u00e1l.<\/p>\n

    <\/a><\/noindex><\/p>\n

    6. ApexSQL Plan<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Ez a teljes\u00edtm\u00e9nyoptimaliz\u00e1l\u00f3 eszk\u00f6z. Az ApexSQL Plannal HTML \u00e9s XML form\u00e1tumban export\u00e1lhat\u00f3k a tervek. Ennek az eszk\u00f6znek a gyakori haszn\u00e1lati esete a jelenlegi terv \u00e9s a m\u00f3dos\u00edtott terv k\u00fcl\u00f6nb\u00f6z\u0151 jellemz\u0151k szerinti \u00f6sszehasonl\u00edt\u00e1sa.<\/p>\n

    \"10
    \n
    \nAz ApexSQL Plan t\u00e1mogatja a lek\u00e9rdez\u00e9si t\u00e1rol\u00f3b\u00f3l val\u00f3 kiad\u00e1st (query store), \u00e9s megjelen\u00edti a lek\u00e9rdez\u00e9sek jellemz\u0151it m\u0171szerfalak form\u00e1j\u00e1ban.<\/p>\n

    <\/a><\/noindex><\/p>\n

    7. ApexSQL Complete<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    A k\u00f3d\u00edr\u00e1s gyors\u00edt\u00f3ja. Az eszk\u00f6z felhaszn\u00e1l\u00f3i fel\u00fclet\u00e9n be\u00e1ll\u00edthat\u00f3k az aliasok, a snippetek \u00e9s a k\u00f3d kiemel\u00e9se.<\/p>\n

    <\/a><\/noindex><\/p>\n

    8. ApexSQL Propagate<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nAz ApexSQL Propagate-ban be\u00e1ll\u00edthat\u00f3 a k\u00f3d v\u00e9grehajt\u00e1s\u00e1nak programoz\u00e1sa k\u00fcl\u00f6nb\u00f6z\u0151 SQL Server adatb\u00e1zisokon, meghat\u00e1rozhat\u00f3 a v\u00e9grehajt\u00e1s sorrendje.<\/p>\n

    \"10
    \n
    \nA v\u00e9grehajtott k\u00f3d eredm\u00e9nyeit az eszk\u00f6z elemzi \u00e9s az eredm\u00e9nyek megtekint\u00e9s\u00e9nek megk\u00f6nny\u00edt\u00e9se \u00e9rdek\u00e9ben r\u00f6gz\u00edti.<\/p>\n

    <\/a><\/noindex><\/p>\n

    9. ApexSQL Search<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Ez az eszk\u00f6z keres\u00e9st v\u00e9gez az adatb\u00e1zis strukt\u00far\u00e1j\u00e1n. Itt biztons\u00e1gosan \u00e1tnevezheti az objektumokat \u00e9s nyomon k\u00f6vetheti azok kapcsolatait. A keres\u00e9si eredm\u00e9nyek HTML, CSV \u00e9s Excel form\u00e1tumban export\u00e1lhat\u00f3k. <\/p>\n

    <\/a><\/noindex><\/p>\n

    10. ApexSQL DevOps Toolkit<\/a><\/noindex><\/h1>\n

    \n\"10
    \n
    \nR\u00f6vid vide\u00f3 a m\u0171k\u00f6d\u00e9si mechanizmusr\u00f3l \u00e9s lehet\u0151s\u00e9geir\u0151l<\/b>

    \r\n \"Vide\u00f3\r\n
    <\/div>\r\n <\/div><\/center><\/p>\n

    Az eszk\u00f6z m\u00f6g\u00f6tt PowerShell k\u00f3d fut. A Build, Review, Document \u00e9s Deploy funkci\u00f3k az ApexSQL DevOps Toolkit felhaszn\u00e1l\u00f3i fel\u00fclet\u00e9r\u0151l \u00e9rhet\u0151k el a fejleszt\u0151k sz\u00e1m\u00e1ra. Itt szintetikus adatok gener\u00e1lhat\u00f3k, automatikusan futtathat\u00f3k az unit tesztek, \u00e9s dokument\u00e1lhat\u00f3k a v\u00e1ltoztat\u00e1sok. Plugink\u00e9nt csatlakoztathat\u00f3 a TeamCityhez, Jenkinshez \u00e9s m\u00e1sokhoz.<\/p>\n

    Az ApexSQL tud\u00e1sb\u00e1zisban tal\u00e1lhat\u00f3 \u00e9rdekes cikkek<\/a><\/noindex> a DevOps-r\u00f3l az adatb\u00e1zisok ter\u00fclet\u00e9n.<\/p>\n

    Most, hogy megismert\u00fck a ingyenes megold\u00e1sokat, r\u00f6viden bemutatjuk a fizet\u0151s megold\u00e1sokat, amelyek term\u00e9szetesen er\u0151sebb funkcionalit\u00e1ssal rendelkeznek.<\/p>\n

      \n
    1. ApexSQL Audit<\/a><\/noindex> \u2014 eszk\u00f6z az adatb\u00e1zisok audit\u00e1l\u00e1s\u00e1ra a biztons\u00e1gi k\u00f6vetelm\u00e9nyeknek val\u00f3 megfelel\u00e9s \u00e9rdek\u00e9ben, bele\u00e9rtve a HIPAA, GDPR, PCI t\u00e1mogat\u00e1s\u00e1t. Jelent\u00e9sek \u00e9s a v\u00e1ltoztat\u00e1sok el\u0151zm\u00e9nyeinek megtekint\u00e9se t\u00e1mogatott.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    2. ApexSQL Backup<\/a><\/noindex> \u2014 az inkrement\u00e1lis biztons\u00e1gi ment\u00e9sek, tranzakci\u00f3s napl\u00f3k \u00e9s teljes biztons\u00e1gi ment\u00e9sek automatiz\u00e1l\u00e1sa. T\u00e1mogatott az id\u0151pontban val\u00f3 vissza\u00e1ll\u00edt\u00e1s, biztons\u00e1gi ment\u00e9si sablonok l\u00e9trehoz\u00e1sa \u00e9s a biztons\u00e1gi ment\u00e9si tervek rugalmas be\u00e1ll\u00edt\u00e1sa.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    3. ApexSQL Defrag<\/a><\/noindex> \u2014 eszk\u00f6z a t\u00f6redezetts\u00e9g figyel\u00e9s\u00e9re \u00e9s kezel\u00e9s\u00e9re.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    4. ApexSQL Job<\/a><\/noindex> \u2014 eszk\u00f6z a feladatok kezel\u00e9s\u00e9re, bele\u00e9rtve a t\u00f6rt\u00e9netet, \u00fctemez\u00e9st \u00e9s \u00e9rtes\u00edt\u00e9seket.\n

      N\u00e9zze meg a k\u00e9pet<\/b>\"10
      \n\n<\/li>\n

    5. ApexSQL Log<\/a><\/noindex> \u2014 eszk\u00f6z a tranzakci\u00f3s napl\u00f3 olvas\u00e1s\u00e1ra audit\u00e1l\u00e1s, replik\u00e1l\u00e1s vagy v\u00e1ltoz\u00e1sok vissza\u00e1ll\u00edt\u00e1sa \u00e9rdek\u00e9ben.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    6. ApexSQL Recover<\/a><\/noindex> \u2014 s\u00e9r\u00fclt, t\u00f6r\u00f6lt vagy elveszett adatok helyre\u00e1ll\u00edt\u00e1sa.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    7. ApexSQL Analyze<\/a><\/noindex> \u2014 eszk\u00f6z az adatb\u00e1zisok k\u00f6z\u00f6tti kapcsolatok elemz\u00e9s\u00e9re.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    8. ApexSQL Build<\/a><\/noindex> \u2014 eszk\u00f6z az adatb\u00e1zis l\u00e9trehoz\u00e1s\u00e1nak automatiz\u00e1l\u00e1s\u00e1ra. Kapcsol\u00f3dhat verzi\u00f3kezel\u0151 rendszerekhez.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    9. ApexSQL Enforce<\/a><\/noindex> \u2014 SQL k\u00f3djav\u00edt\u00f3 eszk\u00f6z.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    10. ApexSQL Generate<\/a><\/noindex> \u2014 eszk\u00f6z milli\u00f3 sor adat gener\u00e1l\u00e1s\u00e1ra egyetlen kattint\u00e1ssal. T\u00e1mogatja a tesztadatok SQL, XML, CSV, JSON \u00e9s Excel form\u00e1tumba t\u00f6rt\u00e9n\u0151 export\u00e1l\u00e1s\u00e1t.\n

      N\u00e9zze meg a k\u00e9pet<\/b>\"10
      \n\n<\/li>\n

    11. ApexSQL Mask<\/a><\/noindex> \u2014 eszk\u00f6z \u00e9rz\u00e9keny adatok keres\u00e9s\u00e9re, oszt\u00e1lyoz\u00e1s\u00e1ra \u00e9s \u00e1lc\u00e1z\u00e1s\u00e1ra az adatb\u00e1zisokban. T\u00f6bb mint 220 el\u0151re defini\u00e1lt maszkot \u00e9s 55 be\u00e9p\u00edtett sz\u0171r\u0151t tartalmaz az oszt\u00e1lyoz\u00e1shoz.\n

      N\u00e9zze meg a k\u00e9pet<\/b>\"10
      \n\n<\/li>\n

    12. ApexSQL Script<\/a><\/noindex> \u2014 eszk\u00f6z DDL \u00e9s DML szkriptek, valamint v\u00e9grehajthat\u00f3 telep\u00edt\u0151csomagok l\u00e9trehoz\u00e1s\u00e1ra.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    13. ApexSQL Source Control<\/a><\/noindex> \u2014 eszk\u00f6z a verzi\u00f3kezel\u0151 rendszerek integr\u00e1l\u00e1s\u00e1ra az SSMS-sel.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    14. ApexSQL Trigger<\/a><\/noindex> \u2014 adatellen\u0151rz\u00e9s az adatb\u00e1zisban \u00e9s DML-re val\u00f3 \u00e1tkonvert\u00e1l\u00e1s.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center><\/p>\n<\/li>\n
    15. ApexSQL Unit Test<\/a><\/noindex> \u2014 eszk\u00f6z egys\u00e9gtesztek v\u00e9grehajt\u00e1s\u00e1ra k\u00f6zvetlen\u00fcl az SSMS konzolb\u00f3l.\n

      N\u00e9zze meg a k\u00e9pet \u00e9s a vide\u00f3t<\/b>\"10
      \n
      \n

      \r\n \"Vide\u00f3\r\n
      <\/div>\r\n <\/div><\/center>\n<\/li>\n<\/ol>\n

      \n\u00cdrja meg hozz\u00e1sz\u00f3l\u00e1sban, hogy milyen eszk\u00f6z\u00f6ket haszn\u00e1l az adatb\u00e1zisok audit\u00e1l\u00e1s\u00e1hoz \u00e9s kezel\u00e9s\u00e9hez, valamint milyen feladatokat old meg vel\u00fck.<\/p>\n

      Ha k\u00e9rd\u00e9se van az ApexSQL term\u00e9kekkel kapcsolatban, szeretne kereskedelmi term\u00e9keket tesztelni vagy \u00e1rat \u00e9rdekl\u0151dni, k\u00e9rj\u00fck, hagyjon egy k\u00e9r\u00e9st a visszajelz\u00e9si \u0171rlapon a weboldalunkon<\/a><\/noindex>.<\/p>\n

      Ha komplex adatkezel\u00e9si feladatot old meg, olvassa el az el\u0151z\u0151 cikk\u00fcnket a Habr-on:<\/p>\n

      K\u00fcl\u00f6nb\u00f6z\u0151 adatb\u00e1zisok monitoroz\u00e1sa egyetlen fel\u00fcletr\u0151l.<\/a><\/noindex><\/p>\n

      A teljes\u00edtm\u00e9nyprobl\u00e9m\u00e1k gyors lokaliz\u00e1l\u00e1sa SQL Serverben.<\/a><\/noindex><\/p>\n

      A Microsoft-infrastrukt\u00far\u00e1k (bele\u00e9rtve a SQL Servert is) v\u00e1ltoz\u00e1sainak audit\u00e1l\u00e1sa.<\/a><\/noindex><\/p>\n

      Emellett feliratkozhat a Facebook oldalunkra<\/a><\/noindex>.
      \n
      Forr\u00e1s:       habr.com<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

      \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 […]<\/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\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd4710 ingyenes ApexSQL seg\u00e9dprogram az Microsoft SQL Server adatb\u00e1zisok kezel\u00e9s\u00e9re | ProHoster","description":"Hell\u00f3, Habr!","canonical_url":"https:\/\/prohoster.info\/hu\/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":"hu_HU","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!","og:url":"https:\/\/prohoster.info\/hu\/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","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/39150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=39150"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/39150\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media\/29381"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=39150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=39150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=39150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}