Created by Robert Twigg on Apr 24, Purpose The purpose of this page is to describe where to obtain the sample Adventureworks database and multidimensional database cube as well as describe the process of bringing them into SQL Server Go to the following CodePlex download page: CodePlex 2. Click "Connect". Right-click "Databases and click "Attach".
Click "OK". Select OK to confirm your database backup selection and close the Select backup devices window. Check the Files tab to confirm the Restore as location and file names match your intended location and file names in the Restore Database wizard. An example to restore AdventureWorks is provided below, but the database name and installation file path may vary depending on your environment. This auto-populates the rest of the fields such as Database , Target database and Restore to.
When you create a new database in Azure SQL Database, you have the option to create a blank database, restore from a backup or select sample data to populate your new database. On the Additional settings tab, choose Sample as the existing data under Data source :. This method does not currently provide data validation so is intended for development and testing and should not be used for production.
If you haven't already done so, restore the sample database to SQL Server. Instead of restoring a database, alternatively, you can use scripts to create the AdventureWorks databases regardless of version. Additional information about using the scripts can be found on GitHub. Once you've restored your sample database, using the following tutorials to get started with SQL Server:. Skip to main content.
In the training I used AdventureWorks database with the table Person. Someone here can help me to download the correct installer or download the same database used during the training? Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. SQL Server Express.
0コメント