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