{"id":110,"date":"2023-06-30T10:01:06","date_gmt":"2023-06-30T10:01:06","guid":{"rendered":"https:\/\/support.visual-store.de\/?page_id=110"},"modified":"2023-10-25T17:51:23","modified_gmt":"2023-10-25T17:51:23","slug":"setting-up-the-databases","status":"publish","type":"page","link":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/","title":{"rendered":"Manual database setup"},"content":{"rendered":"<h1>Manual database setup<\/h1>\n<p>The master database is the main foundation for the functionality of visual-STORE. For this, the master database must be installed on an MS SQL server. If the installation fails via the vstore SQL Manager, it can also be installed manually.<br \/>\nThe SQL Server must be installed for the master database to be installed.<\/p>\n<hr \/>\n<ol style=\"padding: 0px 79px 0px 79px;\">\n<li style=\"list-style-type: none;\">\n<ol style=\"padding: 0px 79px 0px 79px;\">\n<li>Start the <strong>SQL Server Management Studio<\/strong> on your PC.<\/li>\n<li>Log on to the SQL server here with your or the following credentials.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<div style=\"border: 1px solid gray; border-radius: 2px; color: gray; padding: 10px; margin: 10px;\">DB Server Name: <strong>localhost\\VSSQL<\/strong><br \/>\nUsername: <strong>A<\/strong><br \/>\nPassword: <strong>#vsuser12<\/strong><\/div>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/07\/166101004.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Please check if there is an existing database with the name \u201e<strong>VSData<\/strong>\u201cgives.<\/li>\n<li>If this database already exists, it does not need to be created again.<\/li>\n<li>Otherwise, create an empty database named \u201e<strong>VSData<\/strong>\u201can.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/07\/165347511.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>Now the database needs to be restored. To do this, go to the database\u201e<strong>VSData<\/strong>\u201cwith the right mouse button and select the menu \u201e<strong>Tasks-&gt;Restore-&gt;Database<\/strong>\u201c:<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/07\/165806121.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>In the following dialog, the backup file must be selected, which you can usually find under c:\\vsdaten\\vsinstall, here there is<\/li>\n<li>a file (filename: <strong>VSData.bak<\/strong>):<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/07\/165969957.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>For everything to be restored cleanly, one option still needs to be activated.<strong>overwrite existing database<\/strong> under <strong>Options<\/strong>):<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/07\/166035520.jpg\" \/><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>With confirmation of \u201e<strong>Okay<\/strong>\u201cThe master database is being set up. This completes the installation of the master database on the MS SQL Server. You can now exit SQL Server Management Studio.<\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Manuelle Einrichtung der Datenbank Die Master-Datenbank ist die Hauptgrundlage f\u00fcr die Funktionalit\u00e4t von visual-STORE. Dazu muss die Master-Datenbank auf einem MS SQL-Server installiert werden. Sollte die Installation \u00fcber den vstore SQL-Manager scheitern, so kann diese auch manuell installiert werden. Der &hellip; <a class=\"kt-excerpt-readmore more-link\" href=\"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/\">Read More<\/a><\/p>","protected":false},"author":1,"featured_media":0,"parent":63,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-110","page","type-page","status-publish","hentry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/pages\/110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/comments?post=110"}],"version-history":[{"count":10,"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/pages\/110\/revisions"}],"predecessor-version":[{"id":1619,"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/pages\/110\/revisions\/1619"}],"up":[{"embeddable":true,"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/pages\/63"}],"wp:attachment":[{"href":"https:\/\/support.visual-store.de\/en\/wp-json\/wp\/v2\/media?parent=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}