Introduction
This information gives a complete walkthrough for putting in Microsoft SQL Server on Home windows working system.
It covers the mandatory steps to arrange SQL Server, set up SQL Server Database Administration Studio (DBMS), and configure standard pattern databases comparable to AdventureWorks and WideWorldImporters.
Though the procedures outlined are tailor-made for the 2019 model, they’re appropriate with variations launched after 2019.
Thus, this information is a flexible useful resource for establishing SQL Server environments in newer editions as nicely.
Part 1: Putting in SQL Server
- After the file has completed downloading, double-click on it to provoke the set up.
- Within the window that seems, select the “Primary” set up kind.
- Press “Subsequent,” conform to the Phrases and Situations, after which click on “Set up.”
- After the set up is completed, you’ll obtain a hyperlink to obtain SQL Server Administration Studio. In case you don’t spot the hyperlink, please click on on this supplied hyperlink: https://aka.ms/ssmsfullsetup
- Obtain SQL Server Administration Studio and proceed to put in it.
Part 2: AdventureWorks (2019 or 2022) database
- Upon the profitable set up of SQL Server 2019, you’ll require a database for follow. Please comply with the hyperlink under to obtain the AdventureWorks2019 or 2022 Database:
https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks
- On the webpage, find and choose the highlighted choice to obtain the AdventureWorks2019.bak file or AdventureWorks2022.bak file.
- Navigate to the folder the place the AdventureWorks2012.bak file has been downloaded and proceed to make a replica of the file.
- Paste the file into the Backup folder inside your freshly put in SQL system, which must be located in a location resembling the one described under:
C:Program FilesMicrosoft SQL ServerMSSQL11.SQLSERVERBIMSSQLBackup
- Subsequent, open SQL Server Administration Studio from both the Packages Menu or the Functions Desktop (Home windows 8).
Part 3: AdventureWorks knowledge warehouse
- After downloading the file, following comparable steps as in Part 2 to revive the database.
Part 4: WideWorldImporters database
- Guarantee to following the steps as outlined in Part 2 to revive the database.
Wrapping up
This information has detailed the steps required to put in SQL Server 2019, arrange SQL Server Administration Studio, and configure numerous pattern databases together with AdventureWorks and WideWorldImporters.
By following these directions, customers can rapidly set up a practical SQL Server surroundings for growth and testing functions.
Whereas the main focus has been on SQL Server 2019, the procedures are additionally relevant to later variations, making certain that this information stays related for customers working with newer releases of SQL Server.
