Select the device and click on the ellipses icon to select the backup media.Ĭlick on Add button and select the backup file (Downloaded and extracted earlier in the above steps).Īfter selecting the database, click on "OK" button.Ĭlick on "OK" button in "Restore Database" dialog.
Open SQL Server (I am using SQL Server 2014) and right click on "Restore Database". Create the database and tables, import the data, and set up the views and keys with: psql -c 'CREATE DATABASE. Modify the CSVs to work with Postgres by running: ruby updatecsvs.rb. This database can no longer be obtained from any Microsoft web site, and so a backup is made available here. zip and copy all of the CSV files into the same folder, also containing updatecsvs.rb file and install.sql. Download the AdventureWorks database Some of the sample templates which are delivered with XpressDox make use of one of the early instances of the Microsoft AdventureWorks SQL Server database. Visit this URL: to download AdventureWorks Database.Ĭlick on "Adventure Works 2014 Full Database Backup.zip" link.Īfter downloading, extract the database backup file. Download Adventure Works 2014 OLTP Script.
In this blog, we will see how to setup AdventureWorks Database in Microsoft SQL Server. Whenever a new version of SQL Server is released, those newly added features are added to Sample Database. This sample database contains database objects like tables, stored procedures, function, triggers, indexes and sample data. The AdventureWorks database is a sample database that is helpful for new users who are learning Relational Database Management System.