PremiumDB showing the highlights and colors

Premium Vehicle Database Download All Models 1904+ (Year, Make, Model, Trim, Colors, Engine, VIN, Equipment, Options)

$199.00

This vehicle database shows Year, Make, Model, Trim & Highlights + Features for the years 1904-Present.

Note: Highlights and Features only available for vehicles between 1990 – Present.

 

SKU: MSSQL01. Category: . Tag: .

Product Description

 

Superior Premium Vehicle Database Download

& ASP.Net Web Application for years 1904-Present (+ Free Installer)

Database Updated

  • Photos for associated models now available for purchase (see bottom of optional demo), scroll below to view associated PhotoDB product.
  • Download your files via incredibly fast file shares. All files are located in one location after you order. Updates are automatically posted to your account download page and we send out newsletter notifications. See screenshot below.
  • NEW: Vehicle VIN and Engine Data (Can be set up to do reverse lookups – Reverse VIN and Reverse Engine Code – Look Up). VIN data is not comprehensive!
  • The compressed internet download size of the MSSQL database (SQL Server .mdf & log files) is 116MB
  • The compressed internet download size of the MySQL database (SQL dump file) is 112MB
  • The decompressed archived size is just under 2GB! Not your average vehicle database
  • Download Microsoft SQL Server R2 Express for free HERE to use this database
  • View the database samples and field definitions on the “Sample data/Demo” tab
  • Full data/details in MSSQL and MySQL compressed RAR files provided
  • Full Database is also provided in Microsoft Access 2007 version (download size is 89MB expanded to 1.73GB plus Update)
  • With our Superior Premium Vehicle Database Download, you get the most comprehensive vehicle data list compared to our competitor’s. Don’t settle for someone else trying to sell our data!
  • Full vehicle information for years 1990+ include Highlights, Options, Equipment, Engine, VIN, and Colors
  • Part Category table included (great tool for auto recyclers to bind vehicles to parts, etc…)
  • NOTE: Vehicle Years 1904-1989 only show Year, Make, Model, and Trim data fields
  • The provided demo Web Application uses ASP.Net 2.0 Application Pool.
  • Full C# Source Code Included written in ASP.Net C# 3.5 -web app can also be updated to your desired framework version online.
  • Customize the .Net Web Application template to suit your website! Integrate vehicle data right into your website; Cascading Drop Down lists with Year, Make, Model, & Trim, etc.
  • Free ‘Easy One Click Installer’ developed by us. Expedite the database install process! See below for more details.
  • Indexes and Constraints already set for optimum performance and referential integrity.
  • Stored procedures are used by the web application to query corresponding data in the Feature’s tables
  • XML files are provided in the download.  NOTE: The tables “Options, Equipment, and Color” are available in CSV but may not be useable due to the very large file sizes which most software cannot view/edit SEE ERROR. It is possible to export this data from our provided versions by you with other 3rd party tools.  
  • See what table fields are included such as Curb Weight, Engine Size (displacement also in CC’s), Engine Configuration & Code, Cylinders, Horsepower, Torque, Valves, Transmission Type, associated VIN numbers per trim, and more… Click the “Sample Data” tab

Database Metrics

PremiumDB-Totals.doc

Total Records: 42784
New Records as of 30 May: 710

Blazing Fast Downloads & Easy One Click Installer Utility

If you would like to use our easy to use database installer, be sure to have the latest .Net 4.0+ Framework installed to avoid delays. Just unzip and run the program to simplify your database installation. We will also stream updates through the installer in the future.

Our Installer allows you to set the physical and logical names of the database, location, grant file directory permissions to your SQL Server user account and more… View the screenshots!

 


*** How do we get this data out into the script files you purchase? We created a nice SQL Server Management Studio 2008R2 Addin scripting tool that exports all data within a table. Microsoft failed to add an “Insert data to…” function. You can certainly demo this tool we use HERE

 

Additional Information

SQL Server Versions

2008 / 2008 R2 / 2012

Database Download Size

Compressed to 113 Megabytes

Attached (.mdf) File Size

Uncompressed to 1.8 Gigabytes

Easy One Click Installer

Included – Download size: 9 Megabytes

Web Application

C# .Net 3.5 Language / App Pool 2.0 → Upgradable to C# .Net 4.0+ / App Pool 4.0

Sample Data / Demo

Haven’t looked through the demo yet? View Demo

Download a sample of the List with All associated data here: PremiumDB-Sample-Data.zip

Database Field Schema

Vehicle Table Colors Table
[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL PRIMARY KEY
[year] [nvarchar](10) NOT NULL
[make] [nvarchar](150) NOT NULL
[model] [nvarchar](100) NOT NULL
[trim] [nvarchar](150) NULL
[trimShort] [nvarchar](50) NULL
[trimLong] [nvarchar](100) NULL
[vehicle] [nvarchar](255) NULL
[condition] [nvarchar](10) NULL
[vehicleType] [nvarchar](30) NULL
[vehicleSize] [nvarchar](30) NULL
[vehicleStyle] [nvarchar](30) NULL
[vehicleCategory] [nvarchar](50) NULL
[performance] [nvarchar](10) NULL
[luxury] [nvarchar](10) NULL
[market] [nvarchar](150) NULL
[engineCylinder] [nvarchar](5) NULL
[engineSize] [nvarchar](10) NULL
[engineForcedInduction] [nvarchar](50) NULL
[engineFuelType] [nvarchar](50) NULL
[transmissionType] [nvarchar](50) NULL
[transmissionGears] [nvarchar](50) NULL
[whereBuilt] [nvarchar](50) NULL
[manufactureCode] [nvarchar](20) NULL
[acceleration_0to60] [nvarchar](15) NULL
[curbWeight] [nvarchar](15) NULL
[grossWeight] [nvarchar](15) NULL
[numberOfDoors] [nvarchar](15) NULL
[fuelCapacity] [nvarchar](15) NULL
[mpgCity] [nvarchar](15) NULL
[mpgHighway] [nvarchar](15) NULL
[mpgCombined] [nvarchar](15) NULL
[price_baseMSRP] [nvarchar](15) NULL
[price_baseInvoice] [nvarchar](15) NULL
[price_usedRetail] [nvarchar](15) NULL
[price_usedPrivateParty] [nvarchar](15) NULL
[price_deliveryCharges] [nvarchar](15) NOT NULL

[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[colorType] [nvarchar](50) NOT NULL
[colorName] [nvarchar](125) NOT NULL
[colorR] [nvarchar](20) NOT NULL
[colorG] [nvarchar](20) NOT NULL
[colorB] [nvarchar](20) NOT NULL
[colorRGB] [nvarchar](20) NOT NULL
[colorHEX] [nvarchar](20) NOT NULL
[optionCode] [nvarchar](200) NULL

   
Engine Table Options Table

[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[compressionRatio] [nvarchar](20) NOT NULL
[compressionType] [nvarchar](20) NOT NULL
[horsepower] [nvarchar](20) NOT NULL
[name] [nvarchar](150) NOT NULL
[code] [nvarchar](20) NOT NULL
[totalValves] [nvarchar](20) NOT NULL
[fuelType] [nvarchar](150) NOT NULL
[torque] [nvarchar](20) NOT NULL
[cylinder] [nvarchar](20) NOT NULL
[size] [nvarchar](20) NOT NULL
[displacement] [nvarchar](20) NOT NULL
[configuration] [nvarchar](150) NOT NULL
[type] [nvarchar](150) NOT NULL

[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[manufactureOptionName] [nvarchar](255) NULL,
[price] [nvarchar](50) NULL
[equipmentType] [nvarchar](50) NULL
[availability] [nvarchar](600) NULL
[name] [nvarchar](255) NULL
[category] [nvarchar](50) NULL
[manufactureOptionCode] [nvarchar](50) NULL
[description] [nvarchar](max) NULL
   
Equipment Table VIN Table
[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[optionType] [nvarchar](50) NOT NULL,
[optionGroup] [nvarchar](255) NOT NULL,
[optionName] [nvarchar](255) NOT NULL,
[optionValue] [nvarchar](600) NULL
[id] [int] NOT NULL
[styleId] [nvarchar](20) NOT NULL FOREIGN KEY to Vehicle Table
[vin] [nvarchar](50) NOT NULL

You may also like…