Note
1: The links on the Microsoft websites are only valid on 3/13/2014.
Note
2: I have also created folders for different versions of SQL Server on My Google
Docs.
Note
3: Although this document contains the major sample databases and projects, there
are additional samples. You can find more samples at http://sqlserversamples.codeplex.com/.
1.
SQL Server 2000 (My Google Doc Location: https://drive.google.com/#folders/0B0NWdGCu7BBXZjRUZnlYMTZlV00)
I do not have SQL Server 2000 installed on my PC. For
consistency, I have moved the four files – northwind.mdf, northwind.ldf,
pubs.mdf, and pubs.ldf to the same location as the files for SQL Server 2005 at
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
(D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)
(The default path is C:\Program Files\Microsoft SQL
Server\90\Samples\)
For consistency, I have installed it to:
D:\Program Files\Microsoft SQL Server\90\Samples
3.
SQL Server 2008 (SR4 - Sample Refresh 4) (https://drive.google.com/#folders/0B0NWdGCu7BBXYkxMX1lwVS1UcEE)
D:\Program Files\Microsoft SQL
Server\MSSQL10.SQL2008\MSSQL\DATA
Note: When you execute the AdventureWorks2008_SR4.exe, the
executable not only installs the SQL Server 2008 version for the three AW
databases, but it also installs the 2005 version of the three AW databases.
Interestingly, the AW databases for the 2005 and 2008 versions are different. But
the differences are minor after inspection by using SQL Compare (Red Gate). For
instance,
·
AdventureWorks for 2005 uses the collation of Latin1_General_CS_AS
for the nvarchar columns, where AdventureWorks for 2008 employs SQL_Latin1_General_CP1_CI_AS
for the collation
·
AdventureWorks for 2005 has some comments which are not in
the 2008 version
·
There are some minor code changes.
D:\Program Files\Microsoft SQL Server\100\Samples
c.
No separate samples for Report Builder 2.0 with SQL Server
2008.
For Report Builder 2.0 sample reports and tutorials,
you need only install AdventureWorks2008.
a.
Databases: AdventureWorks2008R2 with filestream RTM (SQL2008R2.Data_Engine_and_FTS.Samples.x64.msi),
installed to:
D:\Program Files\Microsoft SQL Server\100\Samples
D:\Program Files\Microsoft SQL
Server\MSSQL10_50.R2\MSSQL\DATA
c.
Other non-DB
Samples: Microsoft SQL
Server 2008 R2 SR 1 ( SQL2008R2.All_Product_Samples_Without_DBs.x64.msi)
Although it is named SQL2008R2, it is actually SQL2008 samples. However,
if you have other 2008R2 samples like the ones in the next list are installed,
the samples for SQL Server 2008 have to be upgraded in the 2008R2 environment. Both
the 2008 and 2008R2 non-DB sample files are installed to:
D:\Program Files\Microsoft SQL Server\100\Samples
d.
Nevertheless, there are some additional samples for SQL Server
2008 R2:
i. SSRS
sample reports: AdventureWorks
Sample Reports 2008 R2 (AdventureWorks Sample Reports 2008 R2.zip), unzipped to:
D:\Program Files\Microsoft SQL Server\100\Samples\AdventureWorks
2008R2 Analysis Services Project\AdventureWorks 2008R2 Analysis Services
Project\enterprise
iii. SSIS
Samples for SQL Server 2008R2 RTM (SQL2008R2.Integration_Services.Samples.x64.msi),
installed to
D:\Program Files\Microsoft SQL Server\100\Samples\Integration
Services
They are just some rdl files.
This database needs to be installed to SQL Azure remotely, not locally.