{"id":7733,"date":"2016-04-28T14:56:16","date_gmt":"2016-04-28T12:56:16","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/"},"modified":"2016-04-28T14:56:16","modified_gmt":"2016-04-28T12:56:16","slug":"the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/","title":{"rendered":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL"},"content":{"rendered":"<p>In previous posts, my colleague <a href=\"http:\/\/dbi-services.com\/blog\/author\/daniel-westermann\/\">Daniel Westermann<\/a> explained how to install the &#8220;<a href=\"http:\/\/linux.dell.com\/dvdstore\/\">Dell DVD Store Database Test Suite&#8221;<\/a> into <a href=\"http:\/\/dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-1-postgresql\/\">PostgreSQL<\/a>, <a href=\"http:\/\/dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-2-oracle\/\">Oracle<\/a> and <a href=\"http:\/\/dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-3-mysqlmariadb\/\">MySQL<\/a>.<\/p>\n<p>This time, this is my job to present you how to proceed with a SQL Server instance \ud83d\ude09<\/p>\n<p>I will proceed this installation on SQL Server 2014 running under Windows Server 2012 R2. To be coherent with the other RDBMS examples, all the manipulation will be made on Windows core. Yes, it is possible to deal with Windows only in command lines \ud83d\ude42<\/p>\n<p>&nbsp;<\/p>\n<p>Please download the <a href=\"http:\/\/linux.dell.com\/dvdstore\/ds21_sqlserver.tar.gz\">ds21_sqlserver.tar.gz<\/a> and <a href=\"http:\/\/linux.dell.com\/dvdstore\/ds21.tar.gz\">ds21.tar.gz<\/a> archives. In my example, I extracted the ds2 archives on &#8220;C:\\&#8221;. The extraction create a ds2 folder, where you find the following items:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS C:\\&gt; ls ds2\n\n    Directory: C:\\ds2\n\nMode                LastWriteTime     Length Name\n----                -------------     ------ ----\nd----        13.04.2016     10:21            data_files\nd----        13.04.2016     10:21            drivers\nd----        13.04.2016     11:19            sqlserverds2\n-a---        12.08.2010     17:08       5308 CreateConfigFile.pl\n-a---        13.05.2011     04:43      30343 ds2.1_Documentation.txt\n-a---        09.11.2011     12:48      10103 ds2_change_log.txt\n-a---        01.07.2005     04:21       1608 ds2_faq.txt\n-a---        05.05.2011     00:25       2363 ds2_readme.txt\n-a---        21.04.2011     03:12       5857 ds2_schema.txt\n-a---        12.05.2005     20:38      18013 gpl.txt\n-a---        09.11.2011     12:45      32827 Install_DVDStore.pl<\/pre>\n<p>If you want to obtain more information, a detailed description is available in &#8220;C:\\ds2\\ds2.1_Documentation.txt&#8221; file.<\/p>\n<p>I recommend you to follow the paths and naming used in this blog, otherwise you must change the different scripts to adapt your own configuration.<\/p>\n<p>First, create the following path: &#8220;C:\\sql\\dbfiles\\&#8221;. Then, open and edit the script located at &#8220;C:\\ds2\\&#8221;:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS C:\\ds2\\sqlserverds2&gt; notepad.exe .\\sqlserverds2_create_all_small.sql\nPS C:\\ds2\\sqlserverds2&gt;<\/pre>\n<p>Choose a password for the login \u201cds2user\u201d created in the script:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8374\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1.png\" alt=\"ds2user_password\" width=\"754\" height=\"495\" \/><\/a><\/p>\n<p>Save and close the edited file.<\/p>\n<p>As ds2 use Perl scripts, Perl must be installed on the server. Simply download the free Community Edition from <a href=\"http:\/\/www.activestate.com\/activeperl\/downloads\">ActiveState<\/a> website, and run the installer.<\/p>\n<p>After Perl is installed on the server, run the &#8220;InstallDVDStore.pl&#8221; script located at &#8220;C:\\ds2\\sqlserverds2&#8221;:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS C:\\ds2&gt; .\\Install_DVDStore.pl\nPS C:\\ds2&gt;<\/pre>\n<p>It will ask for 5 different inputs:<\/p>\n<ul>\n<li>An integer for the size<\/li>\n<li>The unit of the size: MB or GB<\/li>\n<li>The RDBMS type: SQL Server (mssql), MySQL (mysql), Oracle (oracle) or PostgreSQL (PGSQL)<\/li>\n<li>The OS type: Windows (win) or Linux (linux)<\/li>\n<li>The folder path of the database files: &#8220;C:\\sql\\dbfiles&#8221;<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Install_DVDStore1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8381\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Install_DVDStore1.png\" alt=\"Install_DVDStore\" width=\"674\" height=\"342\" \/><\/a><\/p>\n<p>Then execute the &#8220;C:\\ds2\\CreateConfigFile.pl&#8221; script:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CreateConfigFile.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-8377\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CreateConfigFile.png\" alt=\"CreateConfigFile\" width=\"673\" height=\"336\" \/><\/a><\/p>\n<p>Now run this script on the SQL Server instance as follows (in my example, the SQL Server instance is named &#8220;SQL2014&#8221;. Having a different name does not have any impact here):<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS C:\\ds2\\sqlserverds2&gt; Invoke-Sqlcmd -ServerInstance \".\\SQL2014\" -InputFile \".\\sqlserverds2_create_all_small.sql\"<\/pre>\n<p>You can ignore the errors: indeed, it is just some data which have been truncated from the original CSV file which is provided.<\/p>\n<p>&nbsp;<\/p>\n<p>What did happen on my instance?<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS SQLSERVER:\\&gt; Invoke-Sqlcmd -ServerInstance \".\\SQL2014\" -Database \"DS2\" -Username 'ds2user' -Password 'myPa$$w0rd' -Query 'SELECT TABLE_NAME, TABLE_SCHEMA, COLUMN_NAME, DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS'\n\nTABLE_NAME                    TABLE_SCHEMA                  COLUMN_NAME                   DATA_TYPE\n----------                    ------------                  -----------                   ---------\nCUSTOMERS                     dbo                           CUSTOMERID                    int\nCUSTOMERS                     dbo                           FIRSTNAME                     varchar\nCUSTOMERS                     dbo                           LASTNAME                      varchar\nCUSTOMERS                     dbo                           ADDRESS1                      varchar\nCUSTOMERS                     dbo                           ADDRESS2                      varchar\nCUSTOMERS                     dbo                           CITY                          varchar\nCUSTOMERS                     dbo                           STATE                         varchar\nCUSTOMERS                     dbo                           ZIP                           int\nCUSTOMERS                     dbo                           COUNTRY                       varchar\nCUSTOMERS                     dbo                           REGION                        tinyint\nCUSTOMERS                     dbo                           EMAIL                         varchar\nCUSTOMERS                     dbo                           PHONE                         varchar\nCUSTOMERS                     dbo                           CREDITCARDTYPE                tinyint\nCUSTOMERS                     dbo                           CREDITCARD                    varchar\nCUSTOMERS                     dbo                           CREDITCARDEXPIRATION          varchar\nCUSTOMERS                     dbo                           USERNAME                      varchar\nCUSTOMERS                     dbo                           PASSWORD                      varchar\nCUSTOMERS                     dbo                           AGE                           tinyint\nCUSTOMERS                     dbo                           INCOME                        int\nCUSTOMERS                     dbo                           GENDER                        varchar\nCUST_HIST                     dbo                           CUSTOMERID                    int\nCUST_HIST                     dbo                           ORDERID                       int\nCUST_HIST                     dbo                           PROD_ID                       int\nORDERS                        dbo                           ORDERID                       int\nORDERS                        dbo                           ORDERDATE                     datetime\nORDERS                        dbo                           CUSTOMERID                    int\nORDERS                        dbo                           NETAMOUNT                     money\nORDERS                        dbo                           TAX                           money\nORDERS                        dbo                           TOTALAMOUNT                   money\nORDERLINES                    dbo                           ORDERLINEID                   smallint\nORDERLINES                    dbo                           ORDERID                       int\nORDERLINES                    dbo                           PROD_ID                       int\nORDERLINES                    dbo                           QUANTITY                      smallint\nORDERLINES                    dbo                           ORDERDATE                     datetime\nPRODUCTS                      dbo                           PROD_ID                       int\nPRODUCTS                      dbo                           CATEGORY                      tinyint\nPRODUCTS                      dbo                           TITLE                         varchar\nPRODUCTS                      dbo                           ACTOR                         varchar\nPRODUCTS                      dbo                           PRICE                         money\nPRODUCTS                      dbo                           SPECIAL                       tinyint\nPRODUCTS                      dbo                           COMMON_PROD_ID                int\nINVENTORY                     dbo                           PROD_ID                       int\nINVENTORY                     dbo                           QUAN_IN_STOCK                 int\nINVENTORY                     dbo                           SALES                         int\nCATEGORIES                    dbo                           CATEGORY                      tinyint\nCATEGORIES                    dbo                           CATEGORYNAME                  varchar\nREORDER                       dbo                           PROD_ID                       int\nREORDER                       dbo                           DATE_LOW                      datetime\nREORDER                       dbo                           QUAN_LOW                      int\nREORDER                       dbo                           DATE_REORDERED                datetime\nREORDER                       dbo                           QUAN_REORDERED                int\nREORDER                       dbo                           DATE_EXPECTED                 datetime\n\n\nPS SQLSERVER:\\&gt;<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS SQLSERVER:\\&gt; Invoke-Sqlcmd -ServerInstance \".\\SQL2014\" -Database \"DS2\" -Username 'ds2user' -Password 'myPa$$w0rd' -Qu\nery 'SELECT CONSTRAINT_SCHEMA, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME  FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS'\n\nCONSTRAINT_SCHEMA             CONSTRAINT_NAME               CONSTRAINT_TYPE               TABLE_NAME\n-----------------             ---------------               ---------------               ----------\ndbo                           PK_CATEGORIES                 PRIMARY KEY                   CATEGORIES\ndbo                           PK_CUSTOMERS                  PRIMARY KEY                   CUSTOMERS\ndbo                           PK_ORDERS                     PRIMARY KEY                   ORDERS\ndbo                           PK_ORDERLINES                 PRIMARY KEY                   ORDERLINES\ndbo                           FK_ORDERID                    FOREIGN KEY                   ORDERLINES\ndbo                           PK_INVENTORY                  PRIMARY KEY                   INVENTORY\ndbo                           PK_PRODUCTS                   PRIMARY KEY                   PRODUCTS\n\n\nPS SQLSERVER:\\&gt;<\/pre>\n<p>Regarding the size of the database:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">PS SQLSERVER:\\&gt; Invoke-Sqlcmd -ServerInstance \".\\SQL2014\" -Database \"DS2\" -Username 'ds2user' -Password 'myPa$$w0rd' -Query 'SELECT SUM(size\/128) AS Size_MB from sys.database_files'\n\nSize_MB\n-------\n   1019\n\n\nPS SQLSERVER:\\&gt;<\/pre>\n<p>As you can see, we are close to 1000 MB \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In previous posts, my colleague Daniel Westermann explained how to install the &#8220;Dell DVD Store Database Test Suite&#8221; into PostgreSQL, Oracle and MySQL. This time, this is my job to present you how to proceed with a SQL Server instance \ud83d\ude09 I will proceed this installation on SQL Server 2014 running under Windows Server 2012 [&hellip;]<\/p>\n","protected":false},"author":14,"featured_media":7737,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[51],"type_dbi":[],"class_list":["post-7733","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-sql-server"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL - dbi Blog<\/title>\n<meta name=\"description\" content=\"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL\" \/>\n<meta property=\"og:description\" content=\"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-28T12:56:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"754\" \/>\n\t<meta property=\"og:image:height\" content=\"495\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Nathan Courtine\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nathan Courtine\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\"},\"author\":{\"name\":\"Nathan Courtine\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"headline\":\"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL\",\"datePublished\":\"2016-04-28T12:56:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\"},\"wordCount\":389,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png\",\"keywords\":[\"SQL Server\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\",\"name\":\"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png\",\"datePublished\":\"2016-04-28T12:56:16+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\"},\"description\":\"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png\",\"width\":754,\"height\":495},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1\",\"name\":\"Nathan Courtine\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g\",\"caption\":\"Nathan Courtine\"},\"description\":\"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL - dbi Blog","description":"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/","og_locale":"en_US","og_type":"article","og_title":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL","og_description":"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!","og_url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/","og_site_name":"dbi Blog","article_published_time":"2016-04-28T12:56:16+00:00","og_image":[{"width":754,"height":495,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png","type":"image\/png"}],"author":"Nathan Courtine","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Nathan Courtine","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/"},"author":{"name":"Nathan Courtine","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"headline":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL","datePublished":"2016-04-28T12:56:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/"},"wordCount":389,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png","keywords":["SQL Server"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/","url":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/","name":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png","datePublished":"2016-04-28T12:56:16+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1"},"description":"Installation step by step of the Dell DVD Store Database Test Suite on a SQL Server Core instance. The installation on Oracle, MySQL and PostgreSQL is also available!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/ds2user_password1-1.png","width":754,"height":495},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/the-almost-same-sample-schema-for-all-major-relational-databases-4-mssql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The (almost) same sample schema for all major relational databases (4) \u2013 MSSQL"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/38305b5ebdcdb4fb784fa31d760862d1","name":"Nathan Courtine","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0fcc6c91bbc35c976c9d470585e48ae5d500680f1f55de5bbc5f8373b8ebb02c?s=96&d=mm&r=g","caption":"Nathan Courtine"},"description":"Nathan Courtine has more than four years of experience in Microsoft solutions. He is specialized in SQL Server installation, migration, performance analysis, best practices, etc. Moreover, he has a background in Oracle Java and .NET software and web development. Nathan Courtine is Microsoft Certified in Administering SQL Server 2012 Databases. Nathan Courtine holds an Engineer\u2019s Degree in Computer Science from the ENSISA (Ecole Nationale Sup\u00e9rieure d'Ing\u00e9nieurs Sud Alsace) in Mulhouse (F). His branch-related experience covers Public Sector, Automotive, IT, Financial Services \/ Banking, etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/nathan-courtine\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7733"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7733\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7737"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7733"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7733"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7733"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}