SQL Server on linux unable to export to bacpacCan't connect to remote SQL server from some machinesClassic...
What is better: yes / no radio, or simple checkbox?
Activating a Alphanet Faucet Wallet Remotely (without tezos-client)
When does coming up with an idea constitute sufficient contribution for authorship?
Finding ratio of the area of triangles
Metadata API deployments are failing in Spring '19
Find the number of ways to express 1050 as sum of consecutive integers
How can I introduce myself to a party without saying that I am a rogue?
LTSpice: When running a linear AC simulation, how to view the voltage ratio between two voltages?
Why is working on the same position for more than 15 years not a red flag?
Could be quantum mechanics necessary to analyze some biology scenarios?
Can a person refuse a presidential pardon?
How to approximate rolls for potions of healing using only d6's?
'A' vs 'an' in newspaper article
Why zero tolerance on nudity in space?
Can I become debt free or should I file for bankruptcy? How do I manage my debt and finances?
Proof by Induction - New to proofs
Where was Karl Mordo in Infinity War?
Do authors have to be politically correct in article-writing?
c++ How can I make an algorithm for finding variations of a set without repetition (i.e. n elements, choose k)?
Finding the number of integers that are a square and a cube at the same time
If all harmonics are generated by plucking, how does a guitar string produce a pure frequency sound?
Why can I easily sing or whistle a tune I've just heard, but not as easily reproduce it on an instrument?
It took me a lot of time to make this, pls like. (YouTube Comments #1)
Is 45 min enough time to catch my next flight
SQL Server on linux unable to export to bacpac
Can't connect to remote SQL server from some machinesClassic ASP Connection to SQL Server 2014 without TLS 1.0 using ADODB.ConnectionConnect to LocalDB via SQLCMD in PowerShellwhich version SQL server can Install Windows 10?Can not connect to SQL Server from Ubuntu sqlcmd clientSQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog fileSQL Server Management Studio times out connecting to a remote SQL Server engineCan't install SQL SERVER 2017 on Centos 7.4 - mssql-conf setup errorThe system cannot find the file specifiedhelp in connecting the sql server 2017 developer edition
I'm trying to export my database to a .bacpac file. I get the following error:
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The command I'm using is:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:localhost /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
The database I'm trying to back up is on a different ssd than my mssql installation. I don't know if that makes a difference.
I've been googling around for how to fix this and most people using windows had their similar problem solved by making sure that various windows services were running and starting them if they weren't. But I'm not sure how to check for the same thing in linux, but I think all the services I need are currently running because I can connect to the database via sqlcmd as well as through JetBrains' DataGrip application. So I know that a connection is possible. I just don't know why sqlpackage is having trouble connecting...
I've also tried variations of this command on the SourceServerName parameter:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:tcp:localhost,1433 /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
And the error is slightly different:
(provider: TCP Provider, error: 0 - No such host is known.)
sql-server linux bacpac
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm trying to export my database to a .bacpac file. I get the following error:
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The command I'm using is:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:localhost /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
The database I'm trying to back up is on a different ssd than my mssql installation. I don't know if that makes a difference.
I've been googling around for how to fix this and most people using windows had their similar problem solved by making sure that various windows services were running and starting them if they weren't. But I'm not sure how to check for the same thing in linux, but I think all the services I need are currently running because I can connect to the database via sqlcmd as well as through JetBrains' DataGrip application. So I know that a connection is possible. I just don't know why sqlpackage is having trouble connecting...
I've also tried variations of this command on the SourceServerName parameter:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:tcp:localhost,1433 /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
And the error is slightly different:
(provider: TCP Provider, error: 0 - No such host is known.)
sql-server linux bacpac
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I'm trying to export my database to a .bacpac file. I get the following error:
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The command I'm using is:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:localhost /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
The database I'm trying to back up is on a different ssd than my mssql installation. I don't know if that makes a difference.
I've been googling around for how to fix this and most people using windows had their similar problem solved by making sure that various windows services were running and starting them if they weren't. But I'm not sure how to check for the same thing in linux, but I think all the services I need are currently running because I can connect to the database via sqlcmd as well as through JetBrains' DataGrip application. So I know that a connection is possible. I just don't know why sqlpackage is having trouble connecting...
I've also tried variations of this command on the SourceServerName parameter:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:tcp:localhost,1433 /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
And the error is slightly different:
(provider: TCP Provider, error: 0 - No such host is known.)
sql-server linux bacpac
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
I'm trying to export my database to a .bacpac file. I get the following error:
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The command I'm using is:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:localhost /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
The database I'm trying to back up is on a different ssd than my mssql installation. I don't know if that makes a difference.
I've been googling around for how to fix this and most people using windows had their similar problem solved by making sure that various windows services were running and starting them if they weren't. But I'm not sure how to check for the same thing in linux, but I think all the services I need are currently running because I can connect to the database via sqlcmd as well as through JetBrains' DataGrip application. So I know that a connection is possible. I just don't know why sqlpackage is having trouble connecting...
I've also tried variations of this command on the SourceServerName parameter:
/opt/mssql/bin/sqlpackage /action:Export /SourceServerName:tcp:localhost,1433 /SourceDatabaseName:MyDB /targetfile:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
And the error is slightly different:
(provider: TCP Provider, error: 0 - No such host is known.)
sql-server linux bacpac
sql-server linux bacpac
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
asked Jul 1 '17 at 19:42
Jake SmithJake Smith
1113
1113
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
According to the official documentation for SqlPackage on 2017 CTP 2.1, the command to export data and schema is as follows:
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:<your_server> /sdn:<your_database> /su:<username> /sp:<password> /tf:</path/to/your/file.bacpac>
Looking at your command, it appears you're missing credentials, so I'd give this a try (I've shortened the other parameters as well, and removed the TCP port):
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:localhost /sdn:MyDB /su:<user> /sp:<password> /tf:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f177774%2fsql-server-on-linux-unable-to-export-to-bacpac%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
According to the official documentation for SqlPackage on 2017 CTP 2.1, the command to export data and schema is as follows:
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:<your_server> /sdn:<your_database> /su:<username> /sp:<password> /tf:</path/to/your/file.bacpac>
Looking at your command, it appears you're missing credentials, so I'd give this a try (I've shortened the other parameters as well, and removed the TCP port):
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:localhost /sdn:MyDB /su:<user> /sp:<password> /tf:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
add a comment |
According to the official documentation for SqlPackage on 2017 CTP 2.1, the command to export data and schema is as follows:
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:<your_server> /sdn:<your_database> /su:<username> /sp:<password> /tf:</path/to/your/file.bacpac>
Looking at your command, it appears you're missing credentials, so I'd give this a try (I've shortened the other parameters as well, and removed the TCP port):
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:localhost /sdn:MyDB /su:<user> /sp:<password> /tf:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
add a comment |
According to the official documentation for SqlPackage on 2017 CTP 2.1, the command to export data and schema is as follows:
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:<your_server> /sdn:<your_database> /su:<username> /sp:<password> /tf:</path/to/your/file.bacpac>
Looking at your command, it appears you're missing credentials, so I'd give this a try (I've shortened the other parameters as well, and removed the TCP port):
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:localhost /sdn:MyDB /su:<user> /sp:<password> /tf:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
According to the official documentation for SqlPackage on 2017 CTP 2.1, the command to export data and schema is as follows:
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:<your_server> /sdn:<your_database> /su:<username> /sp:<password> /tf:</path/to/your/file.bacpac>
Looking at your command, it appears you're missing credentials, so I'd give this a try (I've shortened the other parameters as well, and removed the TCP port):
/opt/mssql/bin/sqlpackage /a:Export /ssn:tcp:localhost /sdn:MyDB /su:<user> /sp:<password> /tf:'/media/jake/1F171B4C75D06418/MyDB.bacpac'
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
answered Jul 2 '17 at 7:24
Randolph WestRandolph West
2,649215
2,649215
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
add a comment |
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
Does the same error occur using SELECT statements inside SSMS, or sqlcmd?
– Randolph West
Jul 2 '17 at 19:14
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
sqlcmd yes, SSMS yes (through windows vm). I've since taken that other ssd and just installed windows on it and started this whole process over. If I use SSMS to restore the bak file, I don't have any corruption like I did on the linux side.
– Jake Smith
Jul 3 '17 at 19:21
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
Interesting. Do you have any thoughts as to what caused the corruption?
– Randolph West
Jul 3 '17 at 19:22
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
My only guess is that I was restoring something too old to be compatible with SQL server on Linux. No errors during restoration, but reads past a few thousand records would error out 😖
– Jake Smith
Jul 3 '17 at 19:58
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f177774%2fsql-server-on-linux-unable-to-export-to-bacpac%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
