sql-serverssmsazure-data-studio

How to generate .rpt file in Azure Data studio

I am new to SQL Server. I have a Mac so I can't use SSMS. I am using Azure Data Studio and Docker container to run SQL Server. But I am not able to generate .rpt files in Azure Data Studio. I have a .sql file for which I need to generate a .rpt file.

Is there any way to generate .rpt files in Azure Data Studio? We can do that in SSMS. If there is any other way to do that in mac I will try.

I tried searching Azure Data Studio documentation. Also searched Google. Also tried sqlcmd but was not able to run that.

Solution

  • Thanks for the help. We can use the sqlcmd and obcd tools and then run below cmd to create rpt file

    sqlcmd -S localhost -U sa -P <Password> -i /Users/LocationTOFile -o /Users/LocationTOOutputFile.rpt