Sign in
SQL Server Management and Operations
A blog about operating and managing SQL Server
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Blog Home
About
Email Blog Author
Share this
RSS for posts
Atom
RSS for comments
Search
Tags
ADO.NET
codeplex
community
CTP
Databases
Feedback
High Availability
Katmai
Microsoft
Mirroring
Open Source
Plans
release
Reporting Services
RTM
Sample Databases
Samples
SQL
SQL Azure
SQL Server
SQL Server 2005
SQL Server 2008
SQL Server 2008R2
System Center Operations Manager
WPF
Archive
Archives
February 2012
(3)
May 2010
(1)
December 2009
(3)
November 2009
(2)
October 2009
(1)
April 2009
(1)
February 2009
(1)
December 2008
(1)
November 2008
(2)
September 2008
(1)
August 2008
(2)
June 2008
(2)
March 2008
(1)
February 2008
(3)
November 2007
(1)
August 2007
(1)
June 2007
(1)
May 2007
(1)
March 2007
(1)
February 2007
(2)
December 2006
(1)
November 2006
(1)
October 2006
(1)
July 2006
(1)
June 2006
(2)
April 2006
(2)
SQL Server 2008 Samples are here!
MSDN Blogs
>
SQL Server Management and Operations
>
SQL Server 2008 Samples are here!
SQL Server 2008 Samples are here!
BonnieFe
7 Aug 2008 5:44 AM
Comments
3
SQL Server 2008 samples are now available at
http://codeplex.com/SqlServerSamples
. That's our portal page to many different product and community projects on CodePlex with samples for SQL Server. On the releases tab of the portal page you'll find installers for downloading all the code samples. If you're looking for the sample databases for SQL Server 2008, you'll find the project at
http://www.codeplex.com/MSFTDBProdSamples/
. Please look over the content on that page carefully before proceeding to the releases tab for the sample database project (or navigate to
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx
) to download the sample databases and sample database scripts. We have a lot of sample database installers and now zip files for those who have trouble with using the MSI based installers, or who would prefer to inspect the contents before installation. The advantage of using the MSI based installers is that they place the files in an appropriate directory (by default), optionally create shortcuts, and optionally install the databases. A change from SQL Server 2005 and early SQL Server 2008 CTPs is that we now install database backups which are then optionally restored rather than delivering MDF/LDF files which were attached. The backups greatly simplify the deployment of some of the new, exciting features we've put into the v2008 AdventureWorks OLTP sample database which demonstrates cool new features only found in SQL Server 2008. The v2005 sample databases are compatible with the versions we shipped with SQL Server 2005 which can be important if you are running a sample which hasn't been upgraded to use the new schemas we're shipping in the v2008 sample databases. The v2005 and v2008 sample databases use different database names so you should be able to tell by looking at the USE statement in scripts or or the connection string in the sample as to which version of the sample database to use. For example, the v2005 OLTP sample database is named
AdventureWorks
and the v2008 version of the sample database is named
AdventureWorks2008
. You can install v2005 and v2008 side by side. There are schema diagrams published which you can use to see the new schema designs. Note that although the v2005 installers are schema compatible with the schemas we shipped for SQL Server 2005, they are not binary compatible. The sample database installers for SQL Server 2005 are still available, and they are located at
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004
. There is lots more to say about all the great community and product samples for SQL Server 2008. More blog posts to come!
3 Comments
SQL
,
SQL Server 2005
,
Sample Databases
,
Samples
,
Databases
,
Microsoft
,
SQL Server
,
community
,
codeplex
,
release
,
SQL Server 2008
,
Katmai
,
RTM
Blog - Comment List MSDN TechNet
Comments
Loading...
Leave a Comment
Name
Comment
Please add 6 and 5 and type the answer here:
Post