![]() ![]() zip and copy all of the CSV files into the same folder, also containing update_csvs.rb file and install.sql. How to set up the database:ĭownload Adventure Works 2014 OLTP Script.Įxtract the. Primary and foreign keys, and create some of the views used by Adventureworks. Well as a Postgres script to create the tables, load the data, convert the hierarchyid columns, add Provided is a ruby file to convert CSVs available on CodePlex into a format usable by Postgres, as In addition to being a well-rounded OLTP sample, it is also a good choice to demonstrate So it's big enough to be interesting, but not ![]() Sales each having an average of 4 line items. Parts wholesaler with a hierarchy of nearly 300 employees, 500 products, 20000 customers, and 31000 Sales, product, and purchasing data organized across 5 schemas. ![]() Training classes and for sample apps on the Microsoft stack. This project provides the scripts necessary to set up the OLTP part of the go-to database used in ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |