Guest User

Untitled

a guest
Jan 20th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. $ /opt/mssql/bin/sqlpackage /a:Import /tsn:tcp:localhost /tdn:dbName /tu:SA /tp:thePassword /sf:/home/user/Downloads/dbname.bacpac
  2. An unexpected failure occurred: Data plan execution failed with message One or more errors occurred..
  3.  
  4. Unhandled Exception: Microsoft.SqlServer.Dac.Data.DataException: Data plan execution failed with message One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.UnauthorizedAccessException: Access to the path 'C:UsersClientTemptmp4D32.tmp' is denied.
  5. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
  6. at Microsoft.Data.Tools.Schema.Sql.Dac.Data.TemporaryStorageProvider.CreateTemporaryFile(Int64 maxSize)
  7.  
  8. 1> select @@version
  9. 2> go
  10.  
  11. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  12. Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64)
  13. May 10 2017 12:21:23
  14. Copyright (C) 2017 Microsoft Corporation. All rights reserved.
  15. Developer Edition (64-bit) on Linux (Linux Mint 18.1)
  16.  
  17. (1 rows affected)
  18.  
  19. RESTORE DATABASE AdventureWorks
  20. FROM DISK = '/var/opt/mssql/backup/AdventureWorks2014.bak'
  21. WITH MOVE 'AdventureWorks2014_Data' TO '/var/opt/mssql/data/AdventureWorks2014_Data.mdf',
  22. MOVE 'AdventureWorks2014_Log' TO '/var/opt/mssql/data/AdventureWorks2014_Log.ldf'
  23. GO
Add Comment
Please, Sign In to add comment