Azure SQL Database
An Azure relational database service.
6,326 questions
mssql-scripter in Azure Cloud Shell
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 81%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michał Skowronek
1
Reputation point
Hi, I'm trying to get DDL for each tables in Azure SQL Db. I've typed following command to Azure Cloud Shell console
mssql-scripter -S [serwername] -d [databasename] -U [username] -f ./dev.sql
Password: [correctPassword]
and I received an error like below.
No usable version of the libssl was found
Scripting request: 1 encountered error: Scripting request encountered a exception
Error details: ('End of stream reached, no output.',)
What should I do to solve it?
Azure SQL Database
{count} votes
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator2021-12-16T00:27:59.367+00:00 Hi, @Michał Skowronek Welcome to Microsoft Q&A, Thanks for posting your question.
mssql-scripter is a tool where you can install on Windows, Linux, or macOS I don't think it will work on the cloud any reason why you are trying in the cloud please provide more information.Regards
Geetha -
Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator2021-12-16T01:07:01.21+00:00 @GeethaThatipatri-MSFT Please take a look at this article.
-
Michał Skowronek 1 Reputation point
2021-12-16T07:57:16.997+00:00 Thank you for your answer. I tried to do it this way to avoid firewall restrictions. I cannot connect to DB from another host, however, it is possible using could shell and sqlcmd tool. I hoped that mssql-scripter may work in this case based on article https://azure.microsoft.com/en-us/updates/azure-cloud-shell-generate-scripts-by-using-mssql-scripter/
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2021-12-17T01:47:58.603+00:00 Hi, @Michał Skowronek Sorry that I have missed it from the document, currently I am creating it in my environment and will provide you with more details.
Regards
Geetha -
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2021-12-17T06:00:36.733+00:00 Hi, @Michał Skowronek I tried in Windows Azure CLI and it worked fine, however when I tried in Azure cloud I got the same error as you mentioned. i will look into it further and provide more details.
Regards
Geetha -
Michał Skowronek 1 Reputation point
2021-12-17T10:10:30.51+00:00 I'm keeping my fingers crossed.
-
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2021-12-17T22:11:07.42+00:00 Hi @Michał Skowronek I have submitted this issue in our internal git repo so the owner can look into it.
Regards
Geetha -
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2022-01-11T03:44:43.12+00:00 Hi, @Michał Skowronek Thank you for being patient,
to update you on the issue our internal team is investigating the environment and the cause for the error at this time. I will keep you updated once I hear back from the team.Regards
Geetha -
GeethaThatipatri-MSFT 29,542 Reputation points Microsoft Employee Moderator
2022-01-14T18:25:11.81+00:00 Hi, @Michał Skowronek We do not have plans for future releases of mssql-scripter at this time, but the product group would be happy to meet to discuss the challenge of getting an object scripts/definitions. With open-source tools such as mssql-scripter, users are also welcome to adapt the code to meet their needs.
Regards
Geetha
Sign in to comment
Sign in to answer