AdventureWorks2016CTP3.bak#Ubuntu installation?

Question

Can anyone help me how to install AdventureWorks2016CTP3.bak in ubuntu?

thanks in advan

Answer 1

Hi Surendr.a,

AdventureWorks2016CTP3 requires SQL Server 2016 CTP3 installed on Windows 10, Windows 7, Windows 8. Besides, based on my test, I cannot restore it on my SQL Server on Ubuntu successfully with this method: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-restore-database

There is a workaround, we can restore it on a SQL Server 2016 CTP3 instance and then script this database and then run these script on the Linux instance.

Best Regards,

Teige

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

following may help you.

Restore database

1>  restore database [ADv_test] from disk= '/var/opt/mssql/data/AdventureWorks.bak'

2> go Processed 320 pages for database 'ADv_test', file 'AdventureWorks_Data' on file 1. Processed 3 pages for database 'ADv_test', file 'AdventureWorks_Log' on file 1. RESTORE DATABASE successfully processed 323 pages in 1.119 seconds (2.255 MB/sec).

You have full permission on var/opt/mssql/data/ folder.refer following article.

https://social.technet.microsoft.com/wiki/contents/articles/38294.mssql-command-on-linux.aspx

---

https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx