Restore MSSQL server database di ubuntu

ringkasnya ini dimaksudkan untuk merestore database yg dikirimkan dari simda (mssql2000) lanjutkan upgrade oleh mssql2008 dan agar dapat digunakan lebih lanjut oleh mssql2012 di ubuntu.

1. sudo mkdir -p /var/opt/mssql/backup

2. sudo mv /home/user/usersdb_erp_bc.bak /var/opt/mssql/backup/

3. sqlcmd -S localhost -U SA

1> RESTORE FILELISTONLY from DISK = ‘/var/opt/mssql/backup/usersdb_erp_bc.bak’

2> GO

didapatkan logical name database dimaksud

• UsersDB_ERP_QL
• UsersDB_ERP_Log

perintah restore sbb :

1> RESTORE DATABASE UsersDB_ERP_BC

2> FROM DISK = ‘/var/opt/mssql/backup/usersdb_erp_bc.bak’

3> WITH MOVE ‘UsersDB_ERP_QL’ TO ‘/var/opt/mssql/data/UsersDB_ERP.mdf’,

4> MOVE ‘UsersDB_ERP_QL_log’ TO ‘/var/opt/mssql/data/UsersDB_ERP.ldf’

5> GO

selamat mencoba

sumber : https://medium.com/@amalrikmaia/how-to-restore-a-sql-server-database-on-ubuntu-437882a134bf