Home Database Mysql Tutorial AdventureWorks数据库的安装

AdventureWorks数据库的安装

Jun 07, 2016 pm 03:00 PM
download Install Official website database

1.去官方网站下载Adventureworks数据库、然后安装数据库,再用两种方法附加到MS SQL Server2005中,ok? 2.定位到n\Program Files\Microsoft SQL Server\90\Tools\Samples\,然后双击 SqlServerSamples.msi 启动安装程序。(SQL 2005联机丛书) 但是大多Adve

  1.去官方网站下载Adventureworks数据库、然后安装数据库,再用两种方法附加到MS SQL Server2005中,ok?

      2.定位到n\Program Files\Microsoft SQL Server\90\Tools\Samples\,然后双击 SqlServerSamples.msi 启动安装程序。(SQL 2005联机丛书)

但是大多Adventureworks 数据库并非随sql2005一起安装,也同时在sql2005的安装目录下面更本找不到什么AdventureWorks OLTP或AdventureWorksDW目录,更别提其安装脚本(instawdb.sql )了,下面就其实践,和大家分享下,希望指点?

    步骤:1 获取AdventureWorks数据库 

            2 运行安装,将AdventureWorks安装(解压)到指定目录

            3 将得到的数据库文件(AdventureWorks_Data AdventureWorks_Log)copy到你的Sql2005数据目录下

            4 启动sql 2005进入操作界面,在数据库节点上右键->附加(tear off)->浏览指定AdventureWorks_Data->Enter

            5 Ok了,现在你就可以使用AdventureWorks了。

   详细说明:

         1  现在示例数据库Sql Server Sample Database已不在Microsoft  Download板块了,而是到了:www.codeplex.com,在其中有sample databases导航,指示你需要sql2008还是sql2005,在此选择sql2005,进入Sql server 2005 sp2a,

         其中有很多关于AdventureWorks的Sample Database,分类介绍:看了有15个msi文件,分为X86 、X64、IA64,而每一类别中又有DB(OLTP Sample database)、BI(Data Warehouse)、LT(基于AdventureWorks OLTP的简化版database)还有各自的CI版。请选择其中的下载文件,下载AdventureWorks。

        2  接下来的工作就easy了吧

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Introduction to how to download and install the superpeople game Introduction to how to download and install the superpeople game Mar 30, 2024 pm 04:01 PM

The superpeople game can be downloaded through the steam client. The size of this game is about 28G. It usually takes one and a half hours to download and install. Here is a specific download and installation tutorial for you! New method to apply for global closed testing 1) Search for "SUPERPEOPLE" in the Steam store (steam client download) 2) Click "Request access to SUPERPEOPLE closed testing" at the bottom of the "SUPERPEOPLE" store page 3) After clicking the request access button, The "SUPERPEOPLECBT" game can be confirmed in the Steam library 4) Click the install button in "SUPERPEOPLECBT" and download

How to download Beilehu children's songs How to download Beilehu children's songs Mar 28, 2024 am 11:10 AM

As an indispensable accompaniment to children's growth, Beilehu's children's songs have won the love of countless parents and children with their cheerful melody, vivid pictures and entertaining and educational content. In order to allow babies to enjoy the joy brought by children's songs anytime and anywhere, many parents hope to download Beilehu's children's songs to their mobile phones or tablets so that they can listen to their children at any time, but how to save Beilehu's children's songs? On your mobile phone, this tutorial will bring you a detailed introduction. Users who don’t understand it yet can come and read along with this article to learn more. Beilehu Nursery Rhymes Download Children's Songs Multi-Picture Tutorial: Open the software and select a children's song you want to download. The editor takes "Classic Children's Songs" as an example. 2. Click the "Download" button below the children's song star.

How does Go language implement the addition, deletion, modification and query operations of the database? How does Go language implement the addition, deletion, modification and query operations of the database? Mar 27, 2024 pm 09:39 PM

Go language is an efficient, concise and easy-to-learn programming language. It is favored by developers because of its advantages in concurrent programming and network programming. In actual development, database operations are an indispensable part. This article will introduce how to use Go language to implement database addition, deletion, modification and query operations. In Go language, we usually use third-party libraries to operate databases, such as commonly used sql packages, gorm, etc. Here we take the sql package as an example to introduce how to implement the addition, deletion, modification and query operations of the database. Assume we are using a MySQL database.

How to download Kugou Music to your local computer. Tutorial on how to download Kugou Music to your local computer. How to download Kugou Music to your local computer. Tutorial on how to download Kugou Music to your local computer. Mar 28, 2024 pm 01:20 PM

Kugou Music can help us relieve boredom in our daily life. We can listen to many good songs, especially some songs in film and television variety shows. As long as we look for them, they will appear and everyone can listen to them. How do we download the songs we like to listen to locally? Many friends don’t know, so the editor has simply compiled a guide for downloading songs to the local computer for those who are interested. Let's come to this website to check out this guide. I hope it will be helpful to everyone. Tutorial for downloading Kugou Music to your local computer 1. First open Kugou Music and click on the music you want to download on the Kugou Music page; 2. Then enter the page of this music and click on the [three-dot icon] in the lower right corner ; 3. After clicking

How to download qq music to USB flash drive? -How to download qq music to USB disk How to download qq music to USB flash drive? -How to download qq music to USB disk Apr 01, 2024 am 10:11 AM

1. Open QQ Music software, enter the name of your favorite song in the search bar, and click the download button. 2. Open the folder where the downloaded songs are stored. 3. Copy the downloaded songs to the USB flash drive, and that’s it! Of course, you need to open the U disk first, then open the U disk in "My Computer" and paste it.

Essential PHP programs: Install these to run smoothly! Essential PHP programs: Install these to run smoothly! Mar 27, 2024 pm 05:54 PM

Essential PHP programs: Install these to run smoothly! PHP is a popular server-side scripting language that is widely used to develop web applications. To successfully run a PHP program, you first need to install some necessary software and tools on the server. In this article, we will introduce the software and tools that must be installed, along with specific code examples to help you run PHP programs smoothly. 1. PHP interpreter The core of the PHP program is the PHP interpreter, which is responsible for parsing and executing PHP code. To install the PHP interpreter, you can follow

Detailed tutorial on establishing a database connection using MySQLi in PHP Detailed tutorial on establishing a database connection using MySQLi in PHP Jun 04, 2024 pm 01:42 PM

How to use MySQLi to establish a database connection in PHP: Include MySQLi extension (require_once) Create connection function (functionconnect_to_db) Call connection function ($conn=connect_to_db()) Execute query ($result=$conn->query()) Close connection ( $conn->close())

PHP FFmpeg extension installation guide: easy-to-follow tutorial PHP FFmpeg extension installation guide: easy-to-follow tutorial Mar 28, 2024 pm 02:17 PM

PHPFFmpeg Extension Installation Guide: Simple and easy-to-understand tutorial In the process of website development, sometimes we need to process various multimedia files, such as audio, video, etc. FFmpeg is a powerful multimedia processing tool that can process audio, video and other formats, and supports various transcoding, cutting and other operations. The PHPFFmpeg extension is an extension library that calls FFmpeg functions in PHP. It can be used to process multimedia files easily. Below we will introduce PHPF in detail

See all articles