Axeia Posted February 25, 2010 Share Posted February 25, 2010 How does one actually get this adventureworks database installed on SQL Server 2005? There is a nice MSI here: http://msftdbprodsamples.codeplex.com/releases/view/4004 but it fails to add any kind of database and it doesn't seem to install anything. (it doesn't provide any info of what files it's searching where and searching my disk for 'adventureworks' only finds the installer itself) If needed I could try to get one of my classmates to dump it to a file, but it seems there is no dump command.. and the restore/backup options offered within management studio 2005 express only seem to work for your own files. (as in, a restore requires a database to already exist.. and if you try to create it and then 'restore' from a file, it doesn't work). Quote Link to comment https://forums.phpfreaks.com/topic/193322-how-does-one-get-the-adventureworks-test-database-running/ Share on other sites More sharing options...
Brian Swan Posted March 12, 2010 Share Posted March 12, 2010 I think all the .msi does is to lay down the .mdf and .ldf files. You still have to attach the database after that. If you have SQL Server Management Studio, here are instructions for attaching a database: http://msdn.microsoft.com/en-us/library/ms190209.aspx Hope that helps. -Brian Quote Link to comment https://forums.phpfreaks.com/topic/193322-how-does-one-get-the-adventureworks-test-database-running/#findComment-1025377 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.