DBeaver: Restore File Database MS SQL Server (.bak) ke Localhost di Ubuntu Linux

Walim

2 years ago

Restore file database (.bak) SQL Server di Ubuntu. File backup database menggunakan AdventureWorks2019 Lightweight yang dapat diunduh di https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms

SQL Command:

RESTORE FILELISTONLY FROM DISK = N’/home/walim/Desktop/AdventureWorksLT2019.bak’
GO

RESTORE DATABASE AdventureWorksLT2012
FROM DISK = N’/home/walim/Desktop/AdventureWorksLT2019.bak’
WITH MOVE ‘AdventureWorksLT2012_Data’ TO ‘/var/opt/mssql/data/AdventureWorksLT2012.mdf’,
MOVE ‘AdventureWorksLT2012_Log’ TO ‘/var/opt/mssql/data/AdventureWorksLT2012_log.ldf’
GO