I have downloaded AdventureWorksDW2016 which is a .bak file. How do I convert this and import as a database in SSMS? Thanks.
See this page
I am not able to post an example code because my system thinks I am trying to do a SQL injection on someone, there is sample code there as well
Try to create a sample database and restore the AdventureWorksDW2016.bak with overwrite an existing database option.
Can you not just restore the .bak file as a new database?
I have often done this and never had an issue.