Tuesday, March 27, 2012

Downloading sample databases

I am trying to download the sample databases for SQL Server 2005 and SQL
Server 2008.
As I often find to be the case, http://www.codeplex.com is not available. I
have reported this on the codeplex forums in the past. It does not appear
that there has ever been an improvement in the availability of this site.
When I need something from that site, it seems to be unavailable more than it
is available.
Here is the result of running tracert on the site, showing that the problem
is internal within Microsoft's own network:
P:\>tracert www.codeplex.com
Tracing route to www.codeplex.com [207.46.208.126]
over a maximum of 30 hops:
1 <1 ms 1 ms <1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
2 <1 ms <1 ms <1 ms myfirewall-name is company
confidential[xxx.xxx.xxx.xxx]
3 1 ms <1 ms 1 ms myrouter-name is company
confidential[xxx.xxx.xxx.xxx]
4 10 ms 10 ms 9 ms POS1-3.GW6.DFW9.ALTER.NET [xxx.xxx.xxx.xxx]
5 12 ms 11 ms 11 ms 158.at-5-0-0.XR1.DFW9.ALTER.NET
[xxx.xxx.xxx.xxx]
6 13 ms 11 ms 9 ms 0.so-2-1-0.XT3.DFW9.ALTER.NET [152.63.101.249]
7 75 ms 75 ms 76 ms 0.so-7-0-0.XL1.SEA4.ALTER.NET [152.63.104.194]
8 76 ms 75 ms 75 ms 0.so-6-0-0.GW1.SEA4.ALTER.NET [152.63.107.249]
9 76 ms 75 ms 76 ms msft-oc48.customer.alter.net [157.130.177.254]
10 77 ms 78 ms 76 ms ge-5-2-0-54.tuk-64cb-1a.ntwk.msn.net
[207.46.45.
69]
11 * * * Request timed out.
12 * 79 ms 76 ms po1.tuk-6ns-mcs-2a.ntwk.msn.net [207.46.39.33]
13 * * * Request timed out.
14 * po1.tuk-6ns-mcs-2b.ntwk.msn.net [207.46.39.45] reports:
Destinati
on net unreachable.
Trace complete.
Firstly, I would like to suggest/request that the important developer
downloads that have been moved to codeplex.com, such as enterprise library
and sql server sample databases, be made available in the MSDN subscriber
downloads.
Secondly, and more important right now, is that I need those downloads and
the site is not available. I am trying to understand some code from MSDN and
BOL that uses the sample databases. Before I can understand that code so
that I can use the information from BOL in the task I am working on today, I
need to have the sample databases for SQL Server 2005 for certain and,
hopefully, SQL Server 2008. As a MSDN subscriber, please tell me where I can
get those downloads other than the unavailable codeplex.com site.
Thanks,
Dale
Thank you for your uresponse, Gail. I did finally get the samples
downloaded. I attached them to my developer version of SQL Server 2005 by
copying the mdf and ldf files from the default installation in Express
Edition.
*Big sigh of relief*... That was two hours waisted. It probably would not
have been so frustrating if the issues with CodePlex availability didn't
happen so often.
Thanks again for your quick response.
Dale
"Gail Erickson [MS]" wrote:

> Hi Dale,
> I've forwarded your post to the samples team so that they are aware of your
> on-going problem with Codeplex. I notice that you provided similar feedback
> on the Sample Databases page in Codeplex
> (http://www.codeplex.com/MSFTDBProdSamples) today. I assume that means you
> were finally able to download the sample databases. If that's not the case,
> let me know.
> If you have a version of SQL Server 2005 other than the Express or Compact
> editions, you can install the sample databases by re-running setup.See the
> section "Installation After Setup" in the BOL topic "Running Setup to
> Install AdventureWorks Sample Databases and Samples". Cut/paste this URL
> to get to that topic:
> ms-help://sql90/instsql9/html/8c4c2af8-f2ed-4559-b5d2-984a9f7ce5ca.htm
> Right now there is no significant difference between AdventureWorks for 2005
> and AdventureWorks for 2008, so you should be able to use the database for
> either versions of SQL Server.
> --
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> Download the latest version of Books Online from
> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
> "Dale" <dale0973@.nospam.nospam> wrote in message
> news:83FEED8D-9360-4CF8-BEFC-4AC632E5B077@.microsoft.com...
>
>
sql

No comments:

Post a Comment