Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ /opt/mssql/bin/sqlpackage /a:Import /tsn:tcp:localhost /tdn:dbName /tu:SA /tp:thePassword /sf:/home/user/Downloads/dbname.bacpac
- An unexpected failure occurred: Data plan execution failed with message One or more errors occurred..
- 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.
- at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
- at Microsoft.Data.Tools.Schema.Sql.Dac.Data.TemporaryStorageProvider.CreateTemporaryFile(Int64 maxSize)
- 1> select @@version
- 2> go
- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Microsoft SQL Server 2017 (CTP2.1) - 14.0.600.250 (X64)
- May 10 2017 12:21:23
- Copyright (C) 2017 Microsoft Corporation. All rights reserved.
- Developer Edition (64-bit) on Linux (Linux Mint 18.1)
- (1 rows affected)
- RESTORE DATABASE AdventureWorks
- FROM DISK = '/var/opt/mssql/backup/AdventureWorks2014.bak'
- WITH MOVE 'AdventureWorks2014_Data' TO '/var/opt/mssql/data/AdventureWorks2014_Data.mdf',
- MOVE 'AdventureWorks2014_Log' TO '/var/opt/mssql/data/AdventureWorks2014_Log.ldf'
- GO
Add Comment
Please, Sign In to add comment