MicrosoftSQLServerProductSamples: Database

Source: Internet
Author: User
The sample data after SQLServer2005 is "AdventureWorks", which must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database. In addition to the differences in versions, you can also distinguish between OLTP and DW from the following URLs. Select the corresponding version for download. In general, backward compatibility, so

The sample data after SQL Server 2005 is named "AdventureWorks" and must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database. In addition to the differences in versions, you can also distinguish between OLTP and DW from the following URLs. Select the corresponding version for download. In general, backward compatibility, so

The sample data after SQL Server 2005 is named "AdventureWorks" and must be downloaded from the codeplex website. The purpose of this design is to allocate unnecessary users and permissions to the production database.

Access from the following URL

In addition to the version differences, there are also OLTP and DW differences, select the corresponding version for download. Generally, this is backward compatible, so we use AdventureWorks2012 as an example.

Data can be downloaded in multiple ways, such as directly downloading the mdf file, using scripts for installation, or using backups for restoration. It saves time and effort to download mdf for direct Attach.

To install AdventureWorks2012 OLTP database

  • Download the AdventureWorks2012 Data File.
  • From the License Agreement, click I Agree.
  • From File Download, click Save and browse to a location on your local server.
  • From SQL Server Management Studio, execute the following code: change the path name.
  • USE [master]

    GO

    FORATTACH

    GO

    Detach script

    USE [master]

    GO

    EXECmaster. dbo. sp_detach_db

    GO

    To use the graphic interface attach, remove the default Log files.

    Microsoft Sample Database Help documentation

    # Readme_for_Adventure_Workus_Sample_Databases

    Sample Database

    Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.