Adventure Works All DB Scripts.msi not found on codeplex

Question

I have downloaded and ran the adventureworksdw2008.msi, but also need to do the adventureworks all db scripts.msi  .  I can't seem to locate it. 
After this i have to run the builddventureworks.cmd but this was not created on my pc.
Please help

Answer 1

I'm not sure I understand your question.  The msi to download all of the AdventureWorks databases is here: http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=18407#DownloadId=48051    I have no idea what the buildadventureworks.cmd is, but if you run the msi from the link I provided, it should successfully install all of the AdventureWorks databases.

Regards,
Gail

---

Gail Erickson [MS] This posting is provided "AS IS" with no warranties, and confers no rights

Answer 2

Hello,

I have found a file named createadventureworks.cmd  with

@ECHO OFF
ECHO 0: Commandline : %0
ECHO 1: Instance    : %1
ECHO 2: Source Path : %2
ECHO 3: Data Path   : %3
ECHO.
ECHO Creating AW databases.

ECHO TODO Use the environment variables, if no commandline arguments specified.

:: SQL Server 2008 instance name.
:: Remove quotes
SET _instancename=%1
SET _instancename=###%_instancename%###
SET _instancename=%_instancename:"###=%
SET _instancename=%_instancename:###"=%
SET _instancename=%_instancename:###=%
IF "%_instancename%"=="" GOTO Usage

:: Samples common source path, slash-terminated.
:: Remove quotes
SET _sourcepath=%2
SET _sourcepath=###%_sourcepath%###
SET _sourcepath=%_sourcepath:"###=%
SET _sourcepath=%_sourcepath:###"=%
SET _sourcepath=%_sourcepath:###=%
IF "%_sourcepath%"=="" GOTO Usage

:: SQL Server 2008 common root path, slash-terminated.
:: Remove quotes
SET _datapath=%3
SET _datapath=###%_datapath%###
SET _datapath=%_datapath:"###=%
SET _datapath=%_datapath:###"=%
SET _datapath=%_datapath:###=%
IF "%_datapath%"=="" GOTO Usage

:: AdventureWorks ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks OLTP\instawdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

:: AdventureWorksDW ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks Data Warehouse\instawdwdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

:: AdventureWorksLT ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks LT\instawltdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

:: AdventureWorks2008 ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks 2008 OLTP\instawdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

:: AdventureWorksDW2008 ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks 2008 Data Warehouse\instawdwdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

:: AdventureWorksLT2008 ::
sqlcmd -E -S %_instancename% -d master -i "%_sourcepath%AdventureWorks 2008 LT\instawltdb.sql" -b -v SqlSamplesSourceDataPath = "%_sourcepath%" -v SqlSamplesDatabasePath = "%_datapath%"

GOTO Exit

:Usage
ECHO.
ECHO.
ECHO    USAGE
ECHO.
ECHO    Three (3) parameters are required:
ECHO.
ECHO    1. SQL Server 2008 instance name must be specified.
ECHO    2. The SQL Server samples root source data path must be specified.
ECHO    3. SQL Server 2008 common data path for that instance.
ECHO.
ECHO    For example:
ECHO.
ECHO       createadventureworks.cmd ".\SQLSERVER2008" "%PROGRAMFILES%\Microsoft SQL Server\100\" "%PROGRAMFILES%\Microsoft SQL Server\MSSQL10.MSSQLSERVER\"
ECHO.

:Exit
ECHO.
ECHO Script execution complete.
EXIT 0

Maybe the OP has misspelled create into build

In fact, createadventureworks.cmd permits to create the 6 databases.
Is it possible for Gail Erickson to confirm what i suppose .

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

Hello,

Is it possible that someone deletes this thread ?
http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples/thread/e0f9c7a9-aedd-4b83-97b9-659d00e13a46
which is exactly the same than this one

If i remember, only the original poster (MRL5) or a moderator can do that operation ( for MRL5 , it will not be possible from the instant when someone posts a reply ).

It is better not to have twice the same question from the same original poster ( the 1st one has no reply and risks to stay answered ... )

Thanks beforehand and have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.