{"id":9629,"date":"2026-04-21T12:18:45","date_gmt":"2026-04-21T12:18:45","guid":{"rendered":"https:\/\/help.cobra.hu\/?p=9629"},"modified":"2026-07-21T16:40:16","modified_gmt":"2026-07-21T16:40:16","slug":"cobra-db-creator-funkciok","status":"publish","type":"post","link":"https:\/\/help.cobra.hu\/index.php\/2026\/04\/21\/cobra-db-creator-funkciok\/","title":{"rendered":"Cobra.Db.Creator funkci\u00f3k"},"content":{"rendered":"<div id=\"toc_container\" class=\"no_bullets\"><p class=\"toc_title\">Tartalomjegyz&eacute;k<\/p><ul class=\"toc_list\"><li><a href=\"#Elso_inditas\"><span class=\"toc_number toc_depth_1\">1<\/span> Els\u0151 ind\u00edt\u00e1s<\/a><\/li><li><a href=\"#Fokepernyo\"><span class=\"toc_number toc_depth_1\">2<\/span> F\u0151k\u00e9perny\u0151<\/a><\/li><li><a href=\"#Uj_adatbazis_letrehozasa\"><span class=\"toc_number toc_depth_1\">3<\/span> \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa<\/a><\/li><li><a href=\"#Adatbazis_konverzio\"><span class=\"toc_number toc_depth_1\">4<\/span> Adatb\u00e1zis konverzi\u00f3<\/a><\/li><li><a href=\"#Riport_frissites\"><span class=\"toc_number toc_depth_1\">5<\/span> Riport friss\u00edt\u00e9s<\/a><\/li><li><a href=\"#Indexek_ujraepitese\"><span class=\"toc_number toc_depth_1\">6<\/span> Indexek \u00fajra\u00e9p\u00edt\u00e9se<\/a><\/li><li><a href=\"#DDL_DML_Script_futtatasa\"><span class=\"toc_number toc_depth_1\">7<\/span> DDL \/ DML Script futtat\u00e1sa<\/a><\/li><li><a href=\"#SQL_lekerdezes\"><span class=\"toc_number toc_depth_1\">8<\/span> SQL lek\u00e9rdez\u00e9s<\/a><\/li><li><a href=\"#Uj_adatbazis_letrehozasa-2\"><span class=\"toc_number toc_depth_1\">9<\/span> \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa<\/a><\/li><li><a href=\"#Uj_adatbazis_letrehozasa_masolassal\"><span class=\"toc_number toc_depth_1\">10<\/span> \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa m\u00e1sol\u00e1ssal<\/a><\/li><\/ul><\/div>\n<p>A program telep\u00edt\u00e9si k\u00f6nyvt\u00e1r\u00e1b\u00f3l ind\u00edthat\u00f3 Cobra.Db.Creator.exe seg\u00e9dprogram az \u00e1ltalunk haszn\u00e1lt adatb\u00e1zisokr\u00f3l ny\u00fajt inform\u00e1ci\u00f3kat illetve lehet\u0151v\u00e9 teszi azok karbantart\u00e1s\u00e1t.<\/p>\n<h4><span id=\"Elso_inditas\">Els\u0151 ind\u00edt\u00e1s<\/span><\/h4>\n<p>Az els\u0151 ind\u00edt\u00e1s alkalm\u00e1val a Bejelentkez\u00e9s ablakon meg kell adnunk az SQL Server el\u00e9r\u00e9si \u00fatj\u00e1t \u00e9s v\u00e1lasztanunk kell, hogy:<\/p>\n<ul>\n<li>A CobraConto alap, be\u00e9p\u00edtett felhaszn\u00e1l\u00f3j\u00e1val<\/li>\n<li>Windows felhaszn\u00e1l\u00f3i hiteles\u00edt\u00e9ssel<\/li>\n<li>SQL Server felhaszn\u00e1l\u00f3i hiteles\u00edt\u00e9ssel<\/li>\n<\/ul>\n<p>kapcsol\u00f3dunk a szerverhez.<\/p>\n<p id=\"hReHjGd\"><img loading=\"lazy\" width=\"495\" height=\"489\" class=\"size-full wp-image-10052 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f64ed32a4f.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f64ed32a4f.png 495w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f64ed32a4f-300x296.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f64ed32a4f-250x247.png 250w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/p>\n<p>Ett\u0151l az \u00d6n \u00e1ltal haszn\u00e1lt SQL szerveren lehets\u00e9ges, hogy a be\u00e9p\u00edtett felhaszn\u00e1l\u00f3 biztons\u00e1gi okokb\u00f3l tiltva van, ez esetben vagy Windows autentik\u00e1ci\u00f3val vagy a N\u00e9v-jelsz\u00f3 p\u00e1rossal m\u00e1s felhaszn\u00e1l\u00f3i n\u00e9v \u00e9s jelsz\u00f3 haszn\u00e1latos az adatb\u00e1zisok el\u00e9r\u00e9s\u00e9hez. Ebben az esetben forduljon rendszergazd\u00e1j\u00e1hoz.<\/p>\n<p>Amennyiben nem ismerj\u00fck az SQL szerver el\u00e9r\u00e9si \u00fatj\u00e1t, a Cobra.Conto.exe programba bel\u00e9pve, a <strong>Be\u00e1ll\u00edt\u00e1sok \/ Adatb\u00e1zisok<\/strong> men\u00fcpontb\u00f3l ny\u00edl\u00f3 ablakr\u00f3l a Szerver oszlopban tal\u00e1lhat\u00f3 c\u00edmre lesz sz\u00fcks\u00e9g\u00fcnk:<\/p>\n<p id=\"kwKOhAD\"><img loading=\"lazy\" class=\"wp-image-9633 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077.png\" alt=\"\" width=\"973\" height=\"731\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077.png 1533w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077-300x225.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077-1024x769.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077-768x577.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69eb6690dc077-250x188.png 250w\" sizes=\"(max-width: 973px) 100vw, 973px\" \/><\/p>\n<p>Ezek szerint alap\u00e9rtelmezett felhaszn\u00e1l\u00f3val ezt a c\u00edmet haszn\u00e1lva kapcsol\u00f3dunk a szerverre:<\/p>\n<p>&nbsp;<\/p>\n<h4><span id=\"Fokepernyo\">F\u0151k\u00e9perny\u0151<\/span><\/h4>\n<p>Bel\u00e9p\u00e9s ut\u00e1n a f\u0151k\u00e9perny\u0151n a [<strong>Friss\u00edt\u00e9s<\/strong>] gombot megnyomva a t\u00e1bl\u00e1zatban megjelennek az szerveren tal\u00e1lhat\u00f3 adatb\u00e1zisok \u00e9s ezek inform\u00e1ci\u00f3i:<\/p>\n<p id=\"qWUsUOo\"><img loading=\"lazy\" class=\"wp-image-9669 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1faec64f45.png\" alt=\"\" width=\"1039\" height=\"389\" \/><\/p>\n<ul>\n<li>Adatb\u00e1zis: maga az adatb\u00e1zis neve<\/li>\n<li>M\u00e9ret: az adatb\u00e1zis m\u00e9rete MB-ban<\/li>\n<li>C\u00e9g: az adatb\u00e1zisban szerepl\u0151 c\u00e9gn\u00e9v ill. ad\u00f3sz\u00e1m<\/li>\n<li>CCN verzi\u00f3: mely program verzi\u00f3hoz tartozik az adatb\u00e1zis rev\u00edzi\u00f3j\u00e1nak aktu\u00e1lis \u00e9rt\u00e9ke<\/li>\n<li>Rev\u00edzi\u00f3: mi az adatb\u00e1zis rev\u00edzi\u00f3 sz\u00e1m\u00e1nak aktu\u00e1lis \u00e9rt\u00e9ke. Mind a CCN verzi\u00f3, mind a Rev\u00edzi\u00f3 mez\u0151kben a sz\u00ednek jelent\u00e9se:\n<ul>\n<li>Z\u00f6ld: aktu\u00e1lis verzi\u00f3, nem sz\u00fcks\u00e9ges friss\u00edteni<\/li>\n<li>Narancss\u00e1rga: elavult verzi\u00f3, a futtatott Db.Creator verzi\u00f3t\u00f3l r\u00e9gebbi<\/li>\n<\/ul>\n<\/li>\n<li>Riport friss\u00edt\u00e9s: mikor t\u00f6rt\u00e9nt az utols\u00f3 riportfriss\u00edt\u00e9s az adatb\u00e1zisban (Figyelem, amennyiben az Admin program rendszerbe\u00e1ll\u00edt\u00e1sai k\u00f6z\u00f6tt a &#8220;Riport.Haszn\u00e1lat.Visszacsatol\u00e1s&#8221; \u00e9rt\u00e9ke 0, akkor itt \u00fcres vagy nem relev\u00e1ns d\u00e1tum jelenik meg)<\/li>\n<li>T\u00f6redezetts\u00e9g: az adatb\u00e1zisban l\u00e9v\u0151 indexek t\u00f6redezetts\u00e9g\u00e9nek s\u00falyozott \u00e1tlaga. Sz\u00edne 5% alatt z\u00f6ld, 30 alatt narancs, felette piros.<\/li>\n<li>Ment\u00e9s id\u0151pontja: az utols\u00f3 ment\u00e9s id\u0151pontja<\/li>\n<li>Ment\u00e9s m\u00e9rete: az utols\u00f3 ment\u00e9s m\u00e9rete<\/li>\n<li>Ment\u00e9s helye: az utols\u00f3 ment\u00e9s helye<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4><span id=\"Uj_adatbazis_letrehozasa\">\u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa<\/span><\/h4>\n<p>A f\u0151k\u00e9perny\u0151 alj\u00e1n tal\u00e1lhat\u00f3 [\u00daj adat] gomb megnyom\u00e1s\u00e1val ind\u00edthatjuk egy \u00faj adatb\u00e1zis l\u00e9trehoz\u00e1s\u00e1t:<\/p>\n<p>&nbsp;<\/p>\n<h4><span id=\"Adatbazis_konverzio\">Adatb\u00e1zis konverzi\u00f3<\/span><\/h4>\n<p>Amennyiben t\u00f6bb adatb\u00e1zist kezel\u00fcnk \u00e9s a program friss\u00edt\u00e9s telep\u00edt\u00e9se ut\u00e1n sz\u00fcks\u00e9g van adatb\u00e1zis konverzi\u00f3ra is, az Admin program egyenk\u00e9nti futtat\u00e1sa helyett \u00e9rdemes ebben a men\u00fcpontban elv\u00e9gezni adatb\u00e1zisaink \u00e9s riportjaink friss\u00edt\u00e9s\u00e9t.<\/p>\n<p><img loading=\"lazy\" class=\"size-large wp-image-9671 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e-1024x527.png\" alt=\"\" width=\"780\" height=\"401\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e-1024x527.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e-300x154.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e-768x396.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e-250x129.png 250w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff0a4f30e.png 1536w\" sizes=\"(max-width: 780px) 100vw, 780px\" \/><\/p>\n<p>Az ablakon a <strong>C\u00e9lrev\u00edzi\u00f3<\/strong> leg\u00f6rd\u00fcl\u0151ben mindig az aktu\u00e1lisan futtatott Db.Creator verzi\u00f3 utols\u00f3, legfrissebb adatb\u00e1zis rev\u00edzi\u00f3ja ker\u00fcl bet\u00f6lt\u00e9sre. A t\u00e1bl\u00e1zatban csak az ett\u0151l r\u00e9gebbi rev\u00edzi\u00f3 sz\u00e1mmal rendelkez\u0151 adatb\u00e1zisok jelennek meg, hisz ezeket van \u00e9rtelme friss\u00edteni.<br \/>\nA <strong>Riportfriss\u00edt\u00e9ssel<\/strong> kapcsol\u00f3 akt\u00edv \u00e1ll\u00e1sa alap\u00e9rtelmezett, hisz amennyiben az \u00faj verzi\u00f3hoz tartozik friss\u00edtett riport, ezeket is sz\u00fcks\u00e9ges friss\u00edteni. Ehhez kapcsol\u00f3dik az <strong>Auto<\/strong> kapcsol\u00f3, mely akt\u00edv \u00e1llapotban minden elavult riportot lefriss\u00edt, ezt kikapcsolva egy list\u00e1b\u00f3l v\u00e1laszthatjuk ki az elavult riportok k\u00f6z\u00fcl a friss\u00edtend\u0151ket.<\/p>\n<p>A friss\u00edtend\u0151 adatb\u00e1zisok kijel\u00f6l\u00e9se ut\u00e1n nyomjuk meg az [<strong>Ind\u00edt<\/strong>] gombot, ennek hat\u00e1s\u00e1ra a ezeken a fent be\u00e1ll\u00edtottaknak megfelel\u0151en lefutnak az adatb\u00e1zis rev\u00edzi\u00f3hoz tartoz\u00f3 konvert\u00e1l\u00e1sok:<\/p>\n<p id=\"KEvFEIs\"><img loading=\"lazy\" class=\" wp-image-9672 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff544c73c.png\" alt=\"\" width=\"483\" height=\"324\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff544c73c.png 467w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff544c73c-300x201.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ff544c73c-250x168.png 250w\" sizes=\"(max-width: 483px) 100vw, 483px\" \/><\/p>\n<p>A f\u0151k\u00e9perny\u0151re visszat\u00e9rve l\u00e1tni fogjuk, hogy a lekonvert\u00e1lt adatb\u00e1zisaink CCN verzi\u00f3 \u00e9s Rev\u00edzi\u00f3 oszlopaiban a friss adatok szerepelnek, ennek megfelel\u0151en sz\u00edn\u00fck is z\u00f6ld:<\/p>\n<p id=\"JRXRPmb\"><img loading=\"lazy\" width=\"1017\" height=\"140\" class=\"size-full wp-image-9673 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ffdbdb5da.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ffdbdb5da.png 1017w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ffdbdb5da-300x41.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ffdbdb5da-768x106.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1ffdbdb5da-250x34.png 250w\" sizes=\"(max-width: 1017px) 100vw, 1017px\" \/><\/p>\n<p>Ezek ut\u00e1n m\u00e1r bel\u00e9phet\u00fcnk a friss\u00edtett programunkkal a friss verzi\u00f3ra konvert\u00e1lt adatb\u00e1zisainkba.<\/p>\n<p>&nbsp;<\/p>\n<h4><span id=\"Riport_frissites\">Riport friss\u00edt\u00e9s<\/span><\/h4>\n<p>Az ablakban az <strong>Auto<\/strong> kapcsol\u00f3t alap\u00e9rtelmezetten bekapcsolva hagyva egyszerre t\u00f6bb adatb\u00e1zisban is friss\u00edthetj\u00fck a megl\u00e9v\u0151 riportokat:<\/p>\n<p id=\"xDyjLDJ\"><img loading=\"lazy\" class=\" wp-image-10061 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401.png\" alt=\"\" width=\"829\" height=\"345\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401.png 1158w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401-300x125.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401-1024x426.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401-768x320.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7a6835401-250x104.png 250w\" sizes=\"(max-width: 829px) 100vw, 829px\" \/><\/p>\n<p>Az [<strong>Ind\u00edt<\/strong>] gombot megnyomva a kijel\u00f6lt adatb\u00e1zisokon egyenk\u00e9nt v\u00e9gig megy a program, \u00e9s minden riportra megvizsg\u00e1lja, hogy \u00e9rhet\u0151-e el \u00fajabb a Cobra k\u00f6zponti szerver\u00e9n, \u00e9s ha igen, friss\u00edti\u00a0 is azokat.<\/p>\n<p>Ha az <strong>Auto<\/strong> kapcsol\u00f3t kivessz\u00fck, minden adatb\u00e1zisn\u00e1l meg\u00e1ll, \u00e9s felk\u00edn\u00e1lja a riport friss\u00edt\u0151 ablakot, melyen mi d\u00f6nthetj\u00fck el, mely riportokat k\u00edv\u00e1njuk friss\u00edteni:<\/p>\n<p id=\"dwEwXkn\"><img loading=\"lazy\" class=\"wp-image-10062 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05.png\" alt=\"\" width=\"732\" height=\"588\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05.png 1524w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05-300x241.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05-1024x822.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05-768x617.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b497af05-250x201.png 250w\" sizes=\"(max-width: 732px) 100vw, 732px\" \/><\/p>\n<p>Ekkor lehet\u0151s\u00e9g van m\u00e9g nem let\u00f6lt\u00f6tt (<img loading=\"lazy\" width=\"29\" height=\"24\" class=\"alignnone size-full wp-image-10063 \" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7b6fbac85.png\" alt=\"\" \/> ikonnal jel\u00f6lt) riportokat is let\u00f6lteni az adatb\u00e1zisba. Az [<strong>Ind\u00edt<\/strong>] gombot megnyomva a pip\u00e1l\u00e1sainknak megfelel\u0151en az adatb\u00e1zisba friss\u00edt\u00e9sre ill. let\u00f6lt\u00e9sre ker\u00fclnek a kijel\u00f6lt riportok.<\/p>\n<h4><span id=\"Indexek_ujraepitese\">Indexek \u00fajra\u00e9p\u00edt\u00e9se<\/span><\/h4>\n<p>Az SQL Server adatb\u00e1zisokban tal\u00e1lhat\u00f3 t\u00e1bl\u00e1kban tal\u00e1lhat\u00f3 \u00fan. indexek biztos\u00edtj\u00e1k, hogy a t\u00e1bl\u00e1kban tal\u00e1lhat\u00f3 adatok gyorsan kereshet\u0151ek, visszaolvashat\u00f3k legyenek. Ezen indexek a haszn\u00e1lat (\u00edr\u00e1s, t\u00f6rl\u00e9s, friss\u00edt\u00e9s) sor\u00e1n t\u00f6redeznek, \u00e9s ez lass\u00edtja a lek\u00e9rdez\u00e9sek fut\u00e1s\u00e1t. Ez\u00e9rt fontos, hogy id\u0151k\u00f6z\u00f6nk\u00e9nt ezek az indexek \u00fajra\u00e9p\u00edt\u00e9sre ker\u00fcljenek.<\/p>\n<p>Szint\u00e9n a lek\u00e9rdez\u00e9sek fut\u00e1s\u00e1t befoly\u00e1solj\u00e1k az \u00fan. statisztik\u00e1k, melyek <span data-teams=\"true\">befoly\u00e1solj\u00e1k, hogy az SQL Server a lek\u00e9rdez\u00e9seket milyen v\u00e9grehajt\u00e1si terv szerint fogja lefuttatni. Elavult statisztik\u00e1k eset\u00e9n szint\u00e9n lassul\u00e1s k\u00f6vetkezik be a lek\u00e9rdez\u00e9sek v\u00e9grehajt\u00e1s\u00e1n\u00e1l.<\/span><\/p>\n<p>Amennyiben lassul\u00e1st tapasztalunk a program m\u0171k\u00f6d\u00e9s\u00e9ben \u00e9s az adatb\u00e1zis inform\u00e1ci\u00f3k k\u00f6z\u00f6tt a <strong>T\u00f6redezetts\u00e9g<\/strong> oszlop sz\u00edne narancs vagy piros, v\u00e9gezz\u00fck el ezzel a be\u00e9p\u00edtett funkci\u00f3val az ilyen adatb\u00e1zisokban az indexek \u00fajra\u00e9p\u00edt\u00e9s\u00e9t \u00e9s a statisztik\u00e1k friss\u00edt\u00e9s\u00e9t az<strong> Indexek \u00fajra\u00e9p\u00edt\u00e9se<\/strong> funkci\u00f3val:<\/p>\n<ol>\n<li>Jel\u00f6lj\u00fck ki a narancss\u00e1rga \u00e9s piros adatb\u00e1zisokat\n<p id=\"taMZtAh\"><img loading=\"lazy\" class=\"wp-image-9646 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788.png\" alt=\"\" width=\"794\" height=\"521\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788.png 1409w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788-300x197.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788-1024x672.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788-768x504.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69ef3d062e788-250x164.png 250w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><\/p>\n<\/li>\n<li>\n<p id=\"taMZtAh\"><span style=\"font-family: inherit; font-style: inherit; font-weight: inherit;\">Nyomjuk meg az [<\/span><strong style=\"font-size: 14.4px;\">Ind\u00edt<\/strong><span style=\"font-family: inherit; font-style: inherit; font-weight: inherit;\">] gombot<\/span><\/p>\n<\/li>\n<li>A program kijelzi a folyamatot, mely adatb\u00e1zis indexeit \u00e9p\u00edti \u00fajra<\/li>\n<li>V\u00e9g\u00fcl t\u00e1j\u00e9koztat a sikeres index \u00fajra\u00e9p\u00edt\u00e9sr\u0151l \u00e9s friss\u00fcl is az ablak, r\u00f6gt\u00f6n l\u00e1that\u00f3, hogy az indexek t\u00f6redezetts\u00e9ge z\u00f6ld sz\u00ednre v\u00e1ltott, vagyis alacsony lett:\n<p id=\"TyhkdDK\"><img loading=\"lazy\" class=\"wp-image-9670 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68.png\" alt=\"\" width=\"724\" height=\"464\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68.png 1082w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68-300x192.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68-1024x656.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68-768x492.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/04\/img_69f1fc60dbd68-250x160.png 250w\" sizes=\"(max-width: 724px) 100vw, 724px\" \/><\/p>\n<\/li>\n<\/ol>\n<h4><span id=\"DDL_DML_Script_futtatasa\">DDL \/ DML Script futtat\u00e1sa<\/span><\/h4>\n<p>A men\u00fcpontban futtathat\u00f3k az adatb\u00e1zis szerkezet\u00e9t (pl. \u00faj t\u00e1bl\u00e1k l\u00e9trehoz\u00e1sa, megl\u00e9v\u0151k t\u00f6rl\u00e9se vagy m\u00f3dos\u00edt\u00e1sa) \u00e9s a t\u00e1bl\u00e1k tartalm\u00e1t (\u00faj rekordok besz\u00far\u00e1sa\/m\u00f3dos\u00edt\u00e1sa\/t\u00f6rl\u00e9se) m\u00f3dos\u00edt\u00f3 SQL scriptek. Kifejezetten szakembereknek sz\u00e1nt funkci\u00f3.<\/p>\n<p>&nbsp;<\/p>\n<h4><span id=\"SQL_lekerdezes\">SQL lek\u00e9rdez\u00e9s<\/span><\/h4>\n<p>Kifejezetten SQL lek\u00e9rdez\u00e9sek \u00edr\u00e1s\u00e1ra alkalmas ablak. Az ablak jobb oldal\u00e1n az adatb\u00e1zis strukt\u00fara seg\u00e9dben v\u00e1laszthatjuk ki az adatb\u00e1zist, melyre futtatni k\u00edv\u00e1njuk azt. A T\u00e1bl\u00e1k ill. a mez\u0151k nevei dragn&#8217;drop m\u00f3dszerrel beh\u00fazhat\u00f3k az SQL szkript sz\u00f6veg boxba. Emellett lehet\u0151s\u00e9g van m\u00e1r meg\u00edrt SQL lek\u00e9rdez\u00e9s megnyit\u00e1s\u00e1ra ill. az \u00e1ltalunk \u00edrt lek\u00e9rdez\u00e9s ment\u00e9s\u00e9re is.<\/p>\n<p id=\"EliKVom\"><img loading=\"lazy\" width=\"1664\" height=\"891\" class=\"alignnone size-full wp-image-10065 \" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78.png 1664w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78-300x161.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78-1024x548.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78-768x411.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78-1536x822.png 1536w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7d2833c78-250x134.png 250w\" sizes=\"(max-width: 1664px) 100vw, 1664px\" \/><\/p>\n<p>&nbsp;<\/p>\n<h4><span id=\"Uj_adatbazis_letrehozasa-2\">\u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa<\/span><\/h4>\n<p>Amennyiben a szerveren \u00faj adatb\u00e1zist k\u00edv\u00e1nunk l\u00e9trehozni, akkor:<\/p>\n<ol>\n<li>A f\u0151k\u00e9perny\u0151n nyomjuk meg a az [<strong>\u00daj adat<\/strong>] gombot<\/li>\n<li>A megjelen\u0151 k\u00e9perny\u0151n adjuk meg a c\u00e9gnevet \u00e9s \u00faj adatb\u00e1zis nev\u00e9t:\n<p id=\"VeZeZdi\"><img loading=\"lazy\" class=\"alignnone wp-image-10053 \" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869.png\" alt=\"\" width=\"699\" height=\"602\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869.png 1035w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869-300x258.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869-1024x882.png 1024w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869-768x661.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f674571869-250x215.png 250w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><br \/>\nAmennyiben biztons\u00e1gi okokb\u00f3l nem szeretn\u00e9nk hogy egy alap cobra \/ cobra felhaszn\u00e1l\u00f3 l\u00e9trej\u00f6jj\u00f6n, vegy\u00fck ki a pip\u00e1t az <strong>Egy felhaszn\u00e1l\u00f3s bel\u00e9p\u00e9s<\/strong> el\u0151l. Ekkor viszont a Cobra.Admin programban r\u00f6gz\u00edten\u00fcnk kell az \u00faj c\u00e9get haszn\u00e1l\u00f3 usereket.<\/p>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<h4><span id=\"Uj_adatbazis_letrehozasa_masolassal\">\u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa m\u00e1sol\u00e1ssal<\/span><\/h4>\n<p>Amennyiben egy m\u00e1r megl\u00e9v\u0151 adatb\u00e1zist szeretn\u00e9nk m\u00e1solni, majd haszn\u00e1lni, a f\u0151k\u00e9perny\u0151n jel\u00f6lj\u00fck ki a m\u00e1soland\u00f3 c\u00e9get, majd kattintsunk az [<strong>\u00daj adat<\/strong>] gomb lenyit\u00e1s\u00e1ra, majd v\u00e1lasszuk az <strong>\u00daj adat a kiv\u00e1lasztott m\u00e1sol\u00e1s\u00e1val<\/strong> funkci\u00f3t:<\/p>\n<p id=\"VIUJojk\"><img loading=\"lazy\" width=\"785\" height=\"394\" class=\"size-full wp-image-10055 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f754d99392.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f754d99392.png 785w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f754d99392-300x151.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f754d99392-768x385.png 768w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f754d99392-250x125.png 250w\" sizes=\"(max-width: 785px) 100vw, 785px\" \/><\/p>\n<p>Ekkor egy egyszer\u0171 ablakon kiz\u00e1r\u00f3lag a \u00faj, l\u00e9trehozand\u00f3 adatb\u00e1zis nev\u00e9t kell megadnunk:<\/p>\n<p id=\"bbsTntM\"><img loading=\"lazy\" width=\"634\" height=\"394\" class=\"size-full wp-image-10057 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f75f535fa7.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f75f535fa7.png 634w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f75f535fa7-300x186.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f75f535fa7-250x155.png 250w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/p>\n<p>Majd nyomjuk meg az [Ind\u00edt] gombot. Ennek hat\u00e1s\u00e1ra elindul az adatb\u00e1zis kl\u00f3noz\u00e1sa, \u00e9s l\u00e9trej\u00f6n a m\u00e1solt adatb\u00e1zissal tartalmilag teljesen egyez\u0151 adatb\u00e1zis:<\/p>\n<p id=\"WzEIikH\"><img loading=\"lazy\" width=\"641\" height=\"402\" class=\"size-full wp-image-10059 aligncenter\" src=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7639ab6c7.png\" alt=\"\" srcset=\"https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7639ab6c7.png 641w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7639ab6c7-300x188.png 300w, https:\/\/help.cobra.hu\/wp-content\/uploads\/2026\/07\/img_6a5f7639ab6c7-250x157.png 250w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tartalomjegyz&eacute;k1 Els\u0151 ind\u00edt\u00e1s2 F\u0151k\u00e9perny\u01513 \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa4 Adatb\u00e1zis konverzi\u00f35 Riport friss\u00edt\u00e9s6 Indexek \u00fajra\u00e9p\u00edt\u00e9se7 DDL \/ DML Script futtat\u00e1sa8 SQL lek\u00e9rdez\u00e9s9 \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa10 \u00daj adatb\u00e1zis l\u00e9trehoz\u00e1sa m\u00e1sol\u00e1ssal A program telep\u00edt\u00e9si k\u00f6nyvt\u00e1r\u00e1b\u00f3l ind\u00edthat\u00f3 Cobra.Db.Creator.exe seg\u00e9dprogram az \u00e1ltalunk haszn\u00e1lt adatb\u00e1zisokr\u00f3l ny\u00fajt inform\u00e1ci\u00f3kat illetve lehet\u0151v\u00e9 teszi azok karbantart\u00e1s\u00e1t. Els\u0151 ind\u00edt\u00e1s Az els\u0151 ind\u00edt\u00e1s alkalm\u00e1val a Bejelentkez\u00e9s ablakon meg kell adnunk az SQL Server el\u00e9r\u00e9si \u00fatj\u00e1t \u00e9s v\u00e1lasztanunk kell, hogy: A CobraConto alap, be\u00e9p\u00edtett felhaszn\u00e1l\u00f3j\u00e1val Windows felhaszn\u00e1l\u00f3i hiteles\u00edt\u00e9ssel SQL [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[153,44],"tags":[],"_links":{"self":[{"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/posts\/9629"}],"collection":[{"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/comments?post=9629"}],"version-history":[{"count":15,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/posts\/9629\/revisions"}],"predecessor-version":[{"id":10069,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/posts\/9629\/revisions\/10069"}],"wp:attachment":[{"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/media?parent=9629"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/categories?post=9629"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.cobra.hu\/index.php\/wp-json\/wp\/v2\/tags?post=9629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}