{"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>Manual Database Setup The master database is the main foundation for visual-STORE's functionality. This requires the master database to be installed on an MS SQL Server. If the installation fails via the vstore SQL Manager, it can also be installed manually. The... <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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"visual-STORE Support -\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Manuelle Einrichtung der Datenbank - visual-STORE Support\" \/>\n\t\t<meta property=\"og:description\" content=\"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2023-06-30T10:01:06+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2023-10-25T17:51:23+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Manuelle Einrichtung der Datenbank - visual-STORE Support\" \/>\n\t\t<meta name=\"twitter:description\" content=\"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/support.visual-store.de\\\/en\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/#listItem\",\"name\":\"Installationshinweise\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/#listItem\",\"position\":2,\"name\":\"Installationshinweise\",\"item\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#listItem\",\"name\":\"Manuelle Einrichtung der Datenbank\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#listItem\",\"position\":3,\"name\":\"Manuelle Einrichtung der Datenbank\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/#listItem\",\"name\":\"Installationshinweise\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/#organization\",\"name\":\"Visual-Store Support\",\"url\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/support.visual-store.de\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/cropped-Logo.png\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#organizationLogo\",\"width\":999,\"height\":793},\"image\":{\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#organizationLogo\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#webpage\",\"url\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/\",\"name\":\"Manuelle Einrichtung der Datenbank - visual-STORE Support\",\"description\":\"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\\u00e4chst das SQL Server\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/installationshinweise\\\/einrichtung-der-datenbanken\\\/#breadcrumblist\"},\"datePublished\":\"2023-06-30T10:01:06+00:00\",\"dateModified\":\"2023-10-25T17:51:23+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/\",\"name\":\"Visual-Store Support\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/support.visual-store.de\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Manual Database Setup - visual-STORE Support","description":"Manual Database Setup The master database is the main foundation for the functionality of visual-STORE. To do 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. The SQL Server must be installed for the master database installation. First, start the SQL Server","canonical_url":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BreadcrumbList","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en#listItem","position":1,"name":"Home","item":"https:\/\/support.visual-store.de\/en","nextItem":{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/#listItem","name":"Installationshinweise"}},{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/#listItem","position":2,"name":"Installationshinweise","item":"https:\/\/support.visual-store.de\/en\/installationshinweise\/","nextItem":{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#listItem","name":"Manuelle Einrichtung der Datenbank"},"previousItem":{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#listItem","position":3,"name":"Manuelle Einrichtung der Datenbank","previousItem":{"@type":"ListItem","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/#listItem","name":"Installationshinweise"}}]},{"@type":"Organization","@id":"https:\/\/support.visual-store.de\/en\/#organization","name":"Visual-Store Support","url":"https:\/\/support.visual-store.de\/en\/","logo":{"@type":"ImageObject","url":"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#organizationLogo","width":999,"height":793},"image":{"@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#organizationLogo"}},{"@type":"WebPage","@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#webpage","url":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/","name":"Manuelle Einrichtung der Datenbank - visual-STORE Support","description":"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/support.visual-store.de\/en\/#website"},"breadcrumb":{"@id":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/#breadcrumblist"},"datePublished":"2023-06-30T10:01:06+00:00","dateModified":"2023-10-25T17:51:23+00:00"},{"@type":"WebSite","@id":"https:\/\/support.visual-store.de\/en\/#website","url":"https:\/\/support.visual-store.de\/en\/","name":"Visual-Store Support","inLanguage":"en-US","publisher":{"@id":"https:\/\/support.visual-store.de\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"visual-STORE Support -","og:type":"article","og:title":"Manuelle Einrichtung der Datenbank - visual-STORE Support","og:description":"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server","og:url":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/","og:image":"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png","og:image:secure_url":"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png","article:published_time":"2023-06-30T10:01:06+00:00","article:modified_time":"2023-10-25T17:51:23+00:00","twitter:card":"summary_large_image","twitter:title":"Manuelle Einrichtung der Datenbank - visual-STORE Support","twitter:description":"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 SQL Server muss zur Installation der Master-Datenbank installiert sein. Starten Sie zun\u00e4chst das SQL Server","twitter:image":"https:\/\/support.visual-store.de\/wp-content\/uploads\/2023\/06\/cropped-Logo.png"},"aioseo_meta_data":{"post_id":"110","title":null,"description":null,"keywords":[],"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"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":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"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":"WebPage","isEnabled":true},"graphs":[]},"schema_type":"default","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":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2023-06-30 10:01:06","updated":"2025-06-05 10:20:08","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/support.visual-store.de\/en\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/support.visual-store.de\/en\/installationshinweise\/\" title=\"Installationshinweise\">Installationshinweise<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tManuelle Einrichtung der Datenbank\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/support.visual-store.de\/en"},{"label":"Installationshinweise","link":"https:\/\/support.visual-store.de\/en\/installationshinweise\/"},{"label":"Manuelle Einrichtung der Datenbank","link":"https:\/\/support.visual-store.de\/en\/installationshinweise\/einrichtung-der-datenbanken\/"}],"_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}]}}