Sql-server – creating server with Microsoft Server Management Studio

sql serverssms

I am working with a django project and I want to connect it to local server. I downloaded the Microsoft Server Management Studio but got lost on how to create a server and database?

If I am not wrong the object explorer tab only lets you connect to existing server. Is that right? If not how do I create a new server and database in SMSS?

Also I have imported a .bacpac file from the azure cloud and want to duplicate that cloud database in my local machine so that I don't mess up the actual database on cloud while testing. (I followed this link https://stackoverflow.com/questions/5475306/how-do-i-copy-sql-azure-database-to-my-local-development-server)

So how do I create a server/database on local machine using SMSS and load it with the .bacpac file to backup my django site?

Would appreciate the help

Best Answer

SSMS is only a development and management tool. To install a SQL Server instance you need do download and install SQL Server. EG SQL Server Developer Edition. See: https://www.microsoft.com/en-us/sql-server/developer-get-started/

Or provision a SQL Server database in the cloud with Azure SQL Database. https://azure.microsoft.com/en-us/free/services/sql-database/